Rename and standardise

[niklasstepanek]

I have in my file at transmission types "manual", "automatik" and "automatic". I would like to rename all "automatik" to automatic.

Thanks for your help.

[grossal]

Hi @niklasstepanek 

can you provide a minimal sample file?

[niklasstepanek]

Hi @grossal, thanks for replying.

Attached you find the data set. It is the column gearbox.

Thanks

[grossal · Accepted solution]

I noticed that nearly all your values are one of those three, that's why I see two options.

1) do exactly what you requested and leave other values/nulls as it is

2) just change the whole column to 'automatik'

Sample workflow attached.

If this solved your problem, please mark it as a solution or drop another question if it did not solve it.

Alex