Identify and Insert missing rows

KNIME Analytics Platform
#1

Hi,

I have a table of data with some KPIs for each month of the year for each customer ID. All customers are supposed to have Jan to Dec (12 rows) with months with no data recorded as ‘zeros’. But some customers have fewer number of rows.

I am trying to find the customers with missing months and insert the corresponding number of rows(months) with null values for KPIs.

Please help.

#2

Hi,
See attached workflow, hope it helps !

Martin K.

Insert_missing_rows.knwf (13.5 KB)

1 Like
#3

Thank you. I have been able to do this :slight_smile:

#4

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