Mapping two input to replace a column

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,

Output.xlsx

alt_map.xlsx

alt_input_1.xlsx

Datasets

Transformation

Data Investigation

Accepted answers

DataNath

Great. Now you have it appended then you should just be able to use the formula tool from my suggested workflow.

All comments

DataNath

Is this what you're after? Without an identifier like a Record ID I've just matched them side by side as they appear in the data.

If not, let us know and I'll take another look!

Replace blank countries.yxmd

sriniprad08

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,

DataNath

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.

sriniprad08

Hi @DataNath ,

Thank you for the suggestion. I just did the vlookup and appended the country_override column to the dataset.

DataNath

Great. Now you have it appended then you should just be able to use the formula tool from my suggested workflow.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703