Joining dates

[dvdserrano]

Hi Qlik,

I have  a problem when joining 2 dates in 1 to use a single calendar

Firstname Hire Date Termination Date

Jill	1/1/2019	1/2/2019
Eve	5/1/2019	5/2/2019
John	10/1/2019	-

I want me to keep a table like this:

Date

1/1/2019

5/1/2019

10/1/2019

1/2/2019

5/2/2019

And then you can know the date of each employee entering and leaving the company.

Thanks

[ajsjoshua]

Hi,

Load the table twice

load distinct firstname,
HireDate as Date,

'hire' as Flag

load distint firstname
TerminationDate as Date,

'Terminate' as Flag

Then link this Date field to the mastercalendar Date.

[ajsjoshua]

Hi,

PFA https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Regards,

Joshua.