Data shaping question

Hello,

I am pretty new to KNIME and had a question about shaping some data.

I have the following data.

image

What I want to do is split the “Clean” column by “,” and then unpivot them so they fill down. But I want to preserve the “Created” date for each of them. Below is the desired end result, replicated in excel.

image

Thank you!

Hi @fodelement

See this wf data_shaping_question.knwf (21.0 KB)
afbeelding

gr. Hans

3 Likes

Perfect,

This works exactly how I needed it to.

Thank you,

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.