Move head rows to a column
Hi everybody.
I’ve uploaded a csv that uses head rows, identified with specific value, to separate groups of row.
I need to move the data from the head row to a new column, updating the value when a new group starts.
Usually, with excel, I use a If instructions:
if head row → take value from specific column
if not head row → copy the value from this column, previous row
Is it possible to obtain the same result in Knime?
Thanks.