two date-column into one date column

[beck_bakytbek]

Hi Folks,

i got a question, i have 2 columns;

StartDate,    EndDate

02,02.2015    02.12.2017

03.12.2017    03.03.2018

i want to know, is that possible to combine 2 columns into one, if it is possible, how can i concatenate the combined column with my maser calender?

does anybody have any idea?

Beck

[ychaitanya]

Yeah .. by doing the approach i have mentioned above.

we can do following.

1. i have created a timeline chart as follows :

Single_Date as Dimension

Expr Max(Single_Date)-Min(Single_Date)

    Bar  Offset: Min(Single_Date).

All the bars would be plotted across their start and end-dates now.

2. Also in the above logic mentioned we could add "ACTIVE" as Status ,which would keep status as ACTIVE during it's time from Start Date to End Date.

Final _Table:

Load Some_primary_Key,

Temp_Date as Single_Date,

"ACTIVE" as Status

Resident Extract_Table

where Temp_Date>=StartDate and TempDate<=EndDate;

By doing this you could show filter of Status and Calendar(for Single_Date).

I have done the same in previous project and have achieved this, request you to give a try.

Thanks

CY

[beck_bakytbek]

Hi Yelisetty,

thanks a lot for your responce, i appreciate it, do you have an example-file?