Skip to main content
Solved

Transformer values

  • June 13, 2024
  • 5 replies
  • 88 views

tsig
Participant
Forum|alt.badge.img+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.

Best answer by andrewj74

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 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

andrewj74
Supporter
Forum|alt.badge.img+7
  • Supporter
  • June 13, 2024

attribute value mapper :)

 


andrewj74
Supporter
Forum|alt.badge.img+7
  • Supporter
  • June 13, 2024

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.

 

 


tsig
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • June 17, 2024

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

 


andrewj74
Supporter
Forum|alt.badge.img+7
  • Supporter
  • Best Answer
  • June 17, 2024

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 


tsig
Participant
Forum|alt.badge.img+1
  • Author
  • Participant
  • June 17, 2024

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

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

👍