Create new rows in a table

[daviddelos]

Hi,
I’m having this problem when obtaining the information, in some cases when there is more than one contribution by ID and by DATE, I’m getting an additional column in which the value of the second contribution for that same DATE AND ID appears.

It looks like this:

ID CONTRIBUTION DATE COL4
1 $3000 01-05 $685
1 $4000 02-05
2 $2500 02-05

And it should actually look like this:
ID CONTRIBUTION DATE
1 $3000 01-05
1 $685 01-05
1 $4000 02-05
2 $2500 02-05

Does anyone know how I can fix this with Knime?
The ungroup node doesn’t work for me because I don’t have a list of data in that column.

[dyagaty]

May i know what is the source (excel/csv/database table/…) ?
Would you be able to share sample data set ?

[HansS]

Hi @daviddelos

See this workflow create_new_rows.knwf (98.1 KB)

gr. Hans

[dyagaty]

If we are processing large amount of rows, would it help to split the rows first (missing col4 and not missing col4) and transform only the rows with col4. Concat all in the end.