Solved

Transformer values

  • 13 June 2024
  • 5 replies
  • 44 views

Badge +1

Hello everybody, i want to know if someone know how i can to do to rename a value in an attribut ? which name for the transformer ? thank you !!

 

Bonjour tout le monde, je voulais savoir si quelqu’un savait comment modifier une valeur dans un attribut ? quel transformer dois-je utiliser ? Merci par avance.

icon

Best answer by andrewj74 17 June 2024, 10:20

View original

5 replies

Userlevel 3
Badge +5

attribute value mapper :)

 

Userlevel 3
Badge +5

attribute value mapper :)

 

for your “output attribute” name type in the “input attribute” name if you dont want to create a separate column and just update the existing data. also add you attribute to the default value if you are not altering all values

e.g.

 

 

Badge +1

Thank you for your help. 

Effectively it is the good transformer , great! 

However i have three same value, and i want just rename two.

Do you know how i can to do ?

454-454

454-455

454-456

 

Userlevel 3
Badge +5

Thank you for your help. 

Effectively it is the good transformer , great! 

However i have three same value, and i want just rename two.

Do you know how i can to do ?

454-454

454-455

454-456

 

you just put the the value in the input value “454-455” and then what you want it mapped to in the output value. if you want to map 2 values you can add multiple rows to this part.

or do you mean that you  have 3 of the same value and you only want to map one of them. if its just one value i would do a tester to filter out the value e.g 454-455 and then add a sampler to get one row, and then put that value in to the attribute value mapper.

 

 

 if there are lots of potential values where there are more than one an you only want to map one value, you can add a group by clause in the sampler, and group it by the column that has duplicate values where you only want to map one 

Badge +1

It’s good, i have success with your methods.

Thank you for your explanation, it’s very clear.

👍

Reply