Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Code to replace more than 1 value in a column

Hi all,   Do you have any suggestion code/script that I can use to replace all of below value simultaneously beside replace the column value 1 by 1.   PAR01 - 1 PAR02 - 2 PAR03 - 3 PAR04 - 4 ...
Need Help
Show and Tell
Tips and Tricks
  • AllisonKennedy's avatar
    AllisonKennedy
    3 years ago

    Anonymous  For this example it looks like you can use an extract - Last characters. It's in the transform tab, near the replace values button. 

     

    Otherwise you can use a mapping/lookup table and Merge Queries. 

AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous  For this example it looks like you can use an extract - Last characters. It's in the transform tab, near the replace values button. 

 

Otherwise you can use a mapping/lookup table and Merge Queries. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi AllisonKennedy ,

 

Thank you for your support. Currently I use the extract - Last characters. 

How about if all the data is not in sequence, for example below data. Do you have any specific code/script?

 

PAR - 1

LAN - 2

NAT - 3

KOL - 4

YTY - 5

ERT - 6

 

Regards,

Nuha

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous , Sorry, I don't understand what you mean by not in sequence and what you want as a result?