Forum

ReplaceMultipleValu...
 
Notifications
Clear all

ReplaceMultipleValuebyOne

3 Posts
2 Users
0 Reactions
93 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I have to replace multiple Text values by a set of Text values. How can I replace them instead of using replace value from power query. Which I know how to replace one by one.

Please see attached for original Text and the Text to be replaced.

Thank you.

Regards,

Aye

 
Posted : 22/03/2020 10:42 pm
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team

I tried uploading as a table for reference codes and merge the query and I got the result I required.

Is there any other way to do this.

Thank you

Regards,

Aye

 
Posted : 23/03/2020 1:47 am
(@mynda)
Posts: 4765
Member Admin
 

Hi Aye,

That's how I'd do it too.

Mynda

 
Posted : 23/03/2020 6:50 pm
Share: