Hello,
I need to replace a column in my Alteryx workflow with another column from a different excel file.
In my alteryx workflow I have a column where there are a lot of values which say the same thing but are misspelled, inconsistent, appear to have other characters which mean they aren’t grouped together.
So, I created an excel export of these values, de-duplicated, and I created 'standardised' terms of the above values.
Now, I need to import these 'standardised' values into my Alteryx workflow, but I need to make sure that my 'standardised' text from the excel I created replace the correct 'unstandardised' text from the alteryx workflow (the column in the excel file has less rows than the one in Alteryx since it's de-duplicated).
Could you please help me with this?
Thank you
