Replacing Values in Columns with new values

Hi all,

How are you? Could you help me with solving this issue? I want to replace the values in the current format with the values in the desired formats. Because it is a recurrent monthly task, the values in the current format will always be replaced with the values in the desired format every month. I have tried the switch current field in the multifield tool, but it is not working perfectly.

Can someone please help me?

Thanks in advance.

Sample.xlsx

Transformation

Accepted answers

Laurap1228

Hi @Wole_09

Attached is a technique to do multiple 'Find/Replace' at once. Hopefully, this works for you.

Cheers,

Laura

Sample Solution.yxmd

All comments

afv2688

Hello @Wole_09 ,

Could you please explain me a little more what you are looking for? I am sorry but I'm not sure I fully understand your needs.

Regards

Wole_09

Hi,

Thanks for getting in touch!

In the attached excel file, I have two tables. The first one which is the current format is the one I am working on. The second one which is titled Desired format is the one I want as my output.

The task is basically to replace the values in each column in the current table with the values in each column in the desired table.

I hope this helps

afv2688

Hello again @Wole_09,

I don't know if this helps. I am basically using the first 3 columns to find a match from your first table on your second table. If there is a match, I tell the flow to replace the values with the ones coming on the desired one.

Is this helpful?

Regards

Replace_values.yxmd

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280