This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have 2 files and I need to compare the data in one file to the other however, the values in the columns are different. For example in file 1 in the status column the value is Active in file 2 the status column represents the value as a 1. What is the best way to standardize the values in one of the 2 files in order to compare the data?
Thank you for all your help as I am new to Alteryx.
The only way I can think is to create a mapping table. You can then join the mapping table to file 1 on Status1 which would give you the join ID to join your File1 data to File2 in order to find matches and mismatches. You'll have to do mappings for each column that you want to compare.