Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that kinda looks like that :
Name | Attribute | Value
Pot | Color | Red
Pot | Color | Blue
Pot | Color | Yellow
Bag | Color | Red, Yellow
How can I split the Bag row in two so it looks like the Pot ones ?
Thanks for your answers
Hello,
If we understand your requirement is very well, the expected result should be:
Pot | Color | Red
Pot | Color | Blue
Pot | Color | Yellow
Bag | Color | Red
Bag | Color | Yellow
Please have a look at this component about: TalendHelpCenter: tnormalize and related scenario about: TalendHelpCenter: Normalizing data
Feel free to let us know if it helps.
Best regards
Sabrina
Hello,
If we understand your requirement is very well, the expected result should be:
Pot | Color | Red
Pot | Color | Blue
Pot | Color | Yellow
Bag | Color | Red
Bag | Color | Yellow
Please have a look at this component about: TalendHelpCenter: tnormalize and related scenario about: TalendHelpCenter: Normalizing data
Feel free to let us know if it helps.
Best regards
Sabrina