Forum Discussion
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 ...
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.
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
Community Champion
Community ChampionAnonymous , Sorry, I don't understand what you mean by not in sequence and what you want as a result?