Replacing Values in Columns with new values

[Wole_09]

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.

[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

[Laurap1228 · Accepted solution]

Hi @Wole_09 

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

Cheers,

Laura

[Wole_09]

@Laurap1228 ,

Thank you so much for your solution. 

It works perfectly. I m grateful

[Wole_09]

@afv2688 

I really appreciate your time and effort.

Thanks a lot!.

[Wole_09]

But I am still wondering why the Switch([currentfield],.........) formula in the multifield tool didn't work?

See the screenshot below.