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.
piece1, piece2, piece3
Thanks in advance
Yes, no problem. The crux is to use
Split Col col to split into rows.
ANTONIA.transform (3.7 KB)
oooh ! splitting column into rows!! superb
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
@ANTONIA , thanks for asking this question
Here is another way of doing the same with less number of transforms.
Replace to remove any whitespace characters like spaces, tab and such from the pieces column.
Replace to append pieces column values to the name column as per the requirement.
Or you can even do it with two transforms.
CreatingMoreSimilarRows.transform (4.7 KB)
Nicely done. You win this round of Easy Data Transform golf. ;0)
Code golf is a type of recreational computer programming competition in which participants strive to achieve the shortest possible source code that solves a certain problem. Code golf challenges and tournaments may also be named with the programming language used (for example, Perl golf).
The term "code golf" is derived from the similarity of its goal with that of conventional golf, where participants seek to achieve the lowest possible score, rather than the highest, as is the standard in most ...