community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Standardizing data for comparison

Meteoroid

Hi

 

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.

Pulsar

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.

 

Status1Status2
Active1
Passive0
Labels