|
|
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 | |
|
Hide | |
| BETA |
|
| · | AutoMate 10 & AutoMate BPA Server 10 - Public Beta |
| AUTOMATE |
|
| · | Automate 11 |
| · | AutoMate 10 |
| · | AutoMate 9 |
| · | AutoMate 8 |
| · | AutoMate 7 |
| · | AutoMate 6 |
| · | AutoMate 5 |
| AUTOMATE BPA SERVER & AUTOMATE ENTERPRISE |
|
| · | Automate Enterprise 11 |
| · | AutoMate BPA Server 10 |
| · | AutoMate BPA Server 9 |
| · | AutoMate BPA Server 8 |
| · | AutoMate BPA Server 7 |
| GENERAL |
|
| · | General Discussion |
| · | Sample Tasks |
| · | Suggestions |
| · | Lounge |
| KNOWLEDGE BASE |
|
| · | KB Articles |
| · | AutoMate / Automate |
| · | AutoMate BPA Server / Automate Enterprise |
| · | Triggers / Conditions |
| · | Actions / Activities |
| · | Task Builder |
| Automate | |
| AM11 | 11.0.6.11 |
| AutoMate | |
| AM10 | 10.7.0.3 |
| AM9 | 9.0.5.4 |
| AM8 | 8.0.9.0 |
| AM7 | 7.1.3.0 |
| AM6 | 6.2.8.0 |
| AM5 | 5.5.5.1 |
Automate Enterprise
AME11
11.0.6.11
AutoMate BPA Server
BPA10
10.7.0.3
BPA9
9.0.5.4
BPA8
8.0.9.0
BPA7
7.1.3.0
| Insite | |
| 2.2 |
|
Topic Title: Compare two Datasets Topic Summary: Created On: 05/01/2013 02:00 PM Status: Read Only |
Linear : Threading : Single : Branch |
 Search Topic |
Topic Tools
|
 05/01/2013 02:00 PM
|
||||||||||
|
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
|
||||||||||
|
|
||||||||||
|
05/01/2013 02:34 PM
|
||||||||||
|
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 
|
||||||||||
|
|
||||||||||
|
05/02/2013 06:44 AM
|
||||||||||
|
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).
|
||||||||||
|
|
||||||||||
|
05/02/2013 06:47 AM
|
||||||||||
|
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
|
||||||||||
|
|
||||||||||
|
06/14/2013 02:00 PM
|
||||||||||
|
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?
|
||||||||||
|
|
||||||||||
|
06/14/2013 11:41 PM
|
||||||||||
|
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
|
Topic Tools |
FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.
Category Survey