Hi all, I am wondering if there is any tool similar to "select", which would display a table with the unique values in a column and then would allow to rename them? What I want to achieve is something similar to this: Considering a simple table, Number Code1A2B3C4D A will be transformed to UK, B to FR, C to BE, and D to CZ, Number Code1UK2FR3BE4CZ I know this can be achieved with a formula block, but in my original data I have to do >150 conversions, and using formulas does not seem too efficient. I am also thinking about some sort of lookup table, but that would require firstly the construction of that lookup table, which does not seem too efficient either. Cheers

Similar tool to "select" to modify entries in rows (not headers)

Hi all,

I am wondering if there is any tool similar to "select", which would display a table with the unique values in a column and then would allow to rename them?

What I want to achieve is something similar to this:

Considering a simple table,

Number	Code
1	A
2	B
3	C
4	D

A will be transformed to UK, B to FR, C to BE, and D to CZ,

Number	Code
1	UK
2	FR
3	BE
4	CZ

I know this can be achieved with a formula block, but in my original data I have to do >150 conversions, and using formulas does not seem too efficient.

I am also thinking about some sort of lookup table, but that would require firstly the construction of that lookup table, which does not seem too efficient either.

Cheers

Workflow

Accepted answers

OllieClarke

@omar_velor if this is a one off, then I would use a summarise tool to generate the unique list of value pairs. You can then copy this into a text input (or excel file if you wish to retain it) and then update the new names there. The interface of a text input is about as close to what you're after.

You can then use this lookup to either join or use a find and replace tool to update your original data - Find and replace is more performant, but only works with string fields and on single 'find' column. Join tools are more flexible, so it depends on your use case.