Clone Rows of Begin and End Start Dates

If I have an excel record that I am reading in that looks like. I will have about hundreds of records that look similar.

I would like to clone this record with a range of dates from start to end to look like this
I know there is a CLONE ROW object that i can use. I see this link:
www.etl-tools.com/wiki/aetle:processing_...rking_with_clone_row

But I am still not sure how this works. Can you give me additional guidance?

Thanks,
Chuck

I was able to get a working example on my end. It looks a bit different on my Original Post. It works for the most part with the exception of when outputting the Date Range in the WRITER. The Date is not being written to the column of the spreadsheet. Can you take a look and see what is happening?

I am attaching my ExtractDateRange.ats file for your review.

My input is Transform.xlsx
I am only processing the records where the ORIGINAL / REVISED column has a value of 0.
Then, I am cloning the records which share the same columns of
Row,
Company ID
Original /Revised
Cause Number
Circuit ID
Beginning Service Date
Ending Service Date
And I create column as an output called BetweenDaysCount which count the difference of days between my Begin and End Service Dates.

When I get to my Transformation Editor, I am outputting a Date column which increments from the Begin all the way to the End Service Date. For some reason, the output value is not showing up in my TRANSFORMDATES.xlsx file.

Thoughts?
-Chuck

Any ideas why the "Date" column that I am output is not appearing in the WRITER? This is frustrating as it shows the output going to it when I click on the GEAR icon (Process Data) but when running it, it does not get outputted. It disappears?

Thanks,
Chuck

We are currently working on this issue.
www.etl-tools.com/forum/advanced-etl-pro...sformation-tsql.html
we spend all day yesterday and the day before.
Once it is completed., tested, documented and new release published, we will start looking the issue you reported in this tread.

Cool. Thank you so much.

The issue you reported was corrected in the latest release

5.9.3.22

+ Improved: Setup has an option to download Tableau client now
+ Added : SQL Lookup Transformation Function
- Fixed : Scrolling issues
- Fixed : Change date dynamic bug