Modifying existing input table for output table

CloverDX Platform
1

Hi All,

I would like to take this table(Table1) which I have in my database:

Table1

Date
01-01-2017
01-02-2017
01-03-2017

and create a new table(Table2) to my database with the following:

Table2

Start Date End Date
01-01-1990 01-01-2017
01-01-2017 01-02-2017
01-02-2017 01-03-2017
01-03-2017 Current Date

Please help. Is there any way to do it?

2

Yes, solution might look like the one attached. In case incoming data are sorted, you can lose the ExtSort component.