Modifying existing input table for output table

Support/help with CloverETL implementation problems

cloveretluseruser
Posts: 3
Joined: Thu Apr 20, 2017 8:47 am

Modifying existing input table for output table

Postby cloveretluseruser » Thu Apr 20, 2017 9:10 am

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?

svecp
Posts: 25
Joined: Wed Nov 09, 2016 11:51 pm
Location: 2111 Wilson Blvd., Arlington VA 22201
Contact:

Re: Modifying existing input table for output table

Postby svecp » Tue Apr 25, 2017 3:41 pm

Yes, solution might look like the one attached. In case incoming data are sorted, you can lose the ExtSort component.
Attachments
ranges.grf
(4.87 KiB) Downloaded 7 times
--
Pavel Švec | CloverETL | Sales Engineer | 2111 Wilson Blvd | Suite 320 | Arlington, VA 22201


cron