Hi All,
I have data on an excel file which has to be matched with data on a text file. The text file can be converted to an excel file, so essentially we have two excel files.
The data in 1st file looks like below:
Record | A | B | C |
1 | 12abc | 294d | MNX |
Data in 2nd file looks like:
12abc | 294c | MNX |
Task is to pick one record (record 1 in the above example) from the first file and then match every column(A, B, C) values for that specific record with data in second file to check whether it's there or not.
In the above example, 294d from first record is not there in the second file.
In the main data, there are 100s of records and more than 40 columns in the first file. The validation of data points have to be done for all of the records for all the columns.
Can someone please help if there is a way to do it in Alteryx?
hey @Dheeru28, this is very similar to a problem a few days ago - here is the workflow for that problem.
you should be able to easily modify it for your needs :)
Check out these posts
Community > Support > Knowledge > Designer > How To: Compare Data from Two Data sets
Compare 2 Data Sets
https://community.alteryx.com/t5/Engine-Works-Blog/Compare-2-Data-Sets/ba-p/88853
Community > Getting Started > Alteryx Use Cases > Data Check Between Two Sources
https://community.alteryx.com/t5/Alteryx-Use-Cases/Data-Check-Between-Two-Sources/ta-p/270082
Compare field values Left vs Right
Iterative Data Comparison
Combining 2 Data Sets and Highlighting Differences in Output
Chris