Hi ptaylor,
I would like to find a way of splitting the value unit and then add the start date accordingly . I will put it simple we have two fields say units and start date in the mapper . We have many values for the units starting from 1 to n and start date with standard value like yyyy-mm-dd . My expectation is we need to split the start date based on the value units . Let me give an example
Say we have unit 2 and start date as 2020-12-28 and I need two entries like 2020-12-28 and 2020-12-29 . This holds for all unit values . So here I am adding the day of the date each by one until we reach the value unit-1 ( add day of start date with unit starting 0 till unit-1)
I did this before using the sequence snap please suggest is there any other effective ways to achieve this so that I can write in a file completely at once.
Thanks
Hi Ptaylor,
Please find my Parent and Child pipeline and source file known as Excel Date
Pipelines:
Generator.Holiday files_2021_01_30 (1).slp (11.3 KB) Parent Date Pipeline_2021_01_30.slp (7.3 KB)
Source File:Date Generator.xlsx (18.7 KB)
My Expected Output:
My Obtained Output:
May be I am using file overwrite here may be a concern . If we store the same in a oracle table through insert method we could capture all of them . But I need a file writer to this job.
Thanks
