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:
Data in 2nd file looks like:
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?
