Hi Team,
Hope you are well. I need help.
I have a input file and the mapping file.
Please find attached.
I need to replace the blank in the "Country" column with the values from "Country Override".
For e.g if the "Stock location " is "Ca-ab" then based on the "Country Override" column the Value for "Country " column is Canada.
Please let me know how to go about this,
Thanks,
Sr
Solved! Go to Solution.
Hi @DataNath ,
Thank you so much. Really appreciate it. Sorry i might have missed something in posting here. When i run the workflow with my original data. Ideally it gives me the less number of records.
Ideally i should have 24,333 records as the final output. However its only giving me 1807. records.
Please let me know,
thanks,
In your country override table you'll need some sort of identifier that you can match it to the stock location/country on. At the moment there's nothing to tell Alteryx which override belongs to which stock. If you have this then you can then Find & Replace the country names with the overrides or even just join and replace when blank as above.
Hi @DataNath ,
Thank you for the suggestion. I just did the vlookup and appended the country_override column to the dataset.
Great. Now you have it appended then you should just be able to use the formula tool from my suggested workflow.