Duplicate a row with another value

[GBriand]

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

[Anonymous · Accepted solution]

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