Matching data between two files to identify any mismatch

[Dheeru28]

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?

[dwstada]

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 :)

[ChrisTX]

Check out these posts

Community > Support > Knowledge > Designer > How To: Compare Data from Two Data sets

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Compare-Data-from-Two-Data-s...

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

https://community.alteryx.com/t5/Inspire-2019-Buzz/Nested-Macros-Session-Field-Comparison-macro/m-p/...

Iterative Data Comparison

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Iterative-Data-Comparison/td-p/841398/...

Combining 2 Data Sets and Highlighting Differences in Output

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Combining-2-Data-Sets-and-Highlighting...

Chris

[Dheeru28]

Thanks @dwstada and @ChrisTX. I'll check and let you know if I'm able to solve my issue.