Generating new rows based on column value

Hi Team,

I hope to seek your advice on how to archeive below flow:
I have data on grey header as below:
-This data has original name as AA/BB and CC/DD. They also have alternative names “Cat/ Dog/Orange/Apple” and “Cat/ Dog/Orange” accordingly.
-Each original name has certain date.

image

I want to make a flow to generate as 2nd picture below:
when the flow recognize the original name as AA/BB it will generate rows according to reach alternative name with same date.
(AA/BB will genenrate 4 rows with alternative name “Cat”, “Dog”, “Orange”, “Apple” and date as “Mon” in each row. Same to BB/CC)

image

Any method or suggestion to achieve this goal will be appreciated

Thank you so much.

Hi @mysteri_guy

You can split the Alternative Name by a “/” using the Cell Splitter node. Then Unpivot your data, see this wf new_rows_unpivot.knwf (20.3 KB)

afbeelding
gr. Hans

4 Likes