Create gap records based on existing records from the file for a specific period

[VinayM]

Hi,

I have a requirement to create the data for complete year based on the records provided in the file. For example some students had already records with specific period in the year so need to fill the records with missing periods.

Here is the expected output: Need to create the missing period records with in the year with status as “P” as shown below.

Could you please help me on how to create the missing records

[rfeigel]

Could you please upload your data so potential helpers don’t have to manually create it? Both input and output would be helpful.

[HansS]

Hi @VinayM

See this wf CreateGapRecords.knwf (154.9 KB)
The Date&Time Shift node was very helpfull for this solution. With the Create Date&Time Range node you create your first start-date and final end-date manually.

gr. Hans