![]() |
![]() |
We are currently migrating this forum over to our HelpSystems domain. Please post all new threads in our new HelpSystems Community Portal. |
![]() |
|
![]() |
AutoMate Discussion | ![]() |
help :
faq :
home
|
||
Latest News:
|
latest topics : statistics |
Topic Title: Compare two Datasets Topic Summary: Created On: 05/01/2013 02:00 PM Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
||||||||||
Hi, Is there a way to easily compare two datasets within Automate? Both datasets have a common field but i need to see if dataset 1 has records in dataset 2.
Thanks Chris
|
||||||||||
|
||||||||||
![]() |
||||||||||
Chris,
there is no ready made action to do so. looping ds1 and searching ds2each time will be necessary. For performance reasons, it would be better made in basic script. Unless the datasets result from two SQL queries that could be combined to provide directly the result you need.
------------------------- Jean Delfosse - Automate Beta Tester Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4 ![]() |
||||||||||
|
||||||||||
![]() |
||||||||||
Thanks, i'll push the compare to SQL. We have many records and looping through them seems like it would take forever. (from past experience anyways).
|
||||||||||
|
||||||||||
![]() |
||||||||||
You're welcome, Chris. I fully support your final decision.
------------------------- Jean Delfosse - Automate Beta Tester Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4 ![]() |
||||||||||
|
||||||||||
![]() |
||||||||||
You mentioned compaing the two by combining the SQL queries. Can this be done if you have two different SQL connections? My scenario is that I have one table in a database sitting on an SQL 2000 server that need to compare to a table in a database sitting on an SQL 2008 server. What I'm currently doing is reading in the table into a dataset and then looping that dataset making an SQL call to the other table with the where clause to see if there is a matching record. I guess a more efficient way would be to read in both tables into a dataset and compare, but either way seems to be slow. Any suggestions?
|
||||||||||
|
||||||||||
![]() |
||||||||||
NC,
I don't know of a means to SQL query simultaneously with two different connections. And looping the two datasets is lengthy in using Automate loops. But could be substantially faster in basic script.
------------------------- Jean Delfosse - Automate Beta Tester Win7 Pro 64 bits -Win XP Pro SP3 32 bits - AM8, AM7, BPA10, BPA9, BPA8, BPA7, AM6 Enterprise, AM4 ![]() |
||||||||||
|
AutoMate Discussion
» AUTOMATE » AutoMate 7
»
Compare two Datasets
|
![]() |
FuseTalk Enterprise Edition v4.0 - © 1999-2021 FuseTalk Inc. All rights reserved.