Creating more similar rows based on values in a record

[ANTONIA]

Dear Andy,
here I am.
Here is the full question.
Is it possible with your software to create multiple copies of a row adding to each name field of each new row a suffix picked up from a list of values present in another field (a different value suffix for each new row)? So the field with name is costume_1 and has another field with the list piece1, piece2, piece3 I will obtain three new rows with same data and their name field becomes costume_1_piece1, costume_1_piece2, costume1_piece3. Hope to have been clear enough.
After that I want to cancel the original row and remain with derivated rows only.

origin
name	pieces
costume_1	piece1, piece2, piece3
costume_2	piece1, piece3
costume_3	piece5, piece3
costume_4	piece1, piece4
result
costume_1_piece1	piece1
costume_1_piece2	piece2
costume_1_piece3	piece3
costume_2_piece1	piece1
costume_2_piece3	piece3
costume_3_piece5	piece5
costume_3_piece3	piece3
costume_4_piece1	piece1
costume_4_piece4	piece4

Thanks in advance

[Admin]

Yes, no problem. The crux is to use Split Col col to split into rows.

ANTONIA.transform (3.7 KB)

[prashant]

oooh ! splitting column into rows!! superb

[prashant]

For me this would be useful for database splitting single line to multi records

Sales Order 23456
Having Multiple BOM articles inside it and data is collected inside

23456 Silk,Cartons,Paint,Leather X

With above I can get this inside csv and split into multiple lines for parent to multiple child

In short @ANTONIA , thanks for asking this question

[Anonymous]

@ANTONIA,

Here is another way of doing the same with less number of transforms.

First Replace to remove any whitespace characters like spaces, tab and such from the pieces column.

Second Replace to append pieces column values to the name column as per the requirement.

Or you can even do it with two transforms.

Transform File.
CreatingMoreSimilarRows.transform (4.7 KB)

[Admin]

Nicely done. You win this round of Easy Data Transform golf. ;0)

Code golf