Need to Compare Data between two excel or 2 tables
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone i need help to compare data between 2 excel or 2 tables in same database
the column names between 2 excel may vary slightly like (amount in source and value in target)
data may drop in target and new data may be added or source data gets duplicated in target.
i need to figure out above when compare.
I attached source and target excel file
could you hep with workflow
Note: i need to compare 15 excel in same way.
- Labels:
- Data Investigation
- Datasets
- Macros
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Bakiyaraja Do you want to compare each row of the first file against each row of the second file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Yes Binuacs Exactly need to compare 2 excel record by records for each column
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Bakiyaraja In that case I think if you add the record id tool in both the input file and do the join, this will help you to do the row-to-row comparison of both the files
The J - anchor in the join tool will give you the matching records and the other two L and R anchor will return non-matching records from the respective files.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thank you binuacs ,The above solution doesn't work for me because order of records between source and target is not same
in that case we not able to use record ID we generated in the workflow and the join producing wrong result
