Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nezuko_kamado
Creator
Creator

How to combine Two Dates inline tables to one table in script?

How can I combine two inline tables(startDate + peakDate) into one new  table(workDate) in qliksense script?

nezuko_kamado_0-1620846269197.png

startDate:
load * Inline [ startDate
3/4/2021
3/5/2021
3/8/2021
3/10/2021
3/14/2021
3/15/2021
3/16/2021
3/20/2021
3/21/2021
3/23/2021
3/24/2021
];

peakDate:
load * Inline [ peakDate
3/5/2021
3/9/2021
3/10/2021
3/11/2021
];

Labels (2)
1 Reply
GaryGiles
Specialist
Specialist

Try this:

DateTable:
load startDate, startDate as workDate Inline [ startDate
3/4/2021
3/5/2021
3/8/2021
3/10/2021
3/14/2021
3/15/2021
3/16/2021
3/20/2021
3/21/2021
3/23/2021
3/24/2021
];

join (DateTable)
load peakDate, peakDate as workDate Inline [peakDate
3/5/2021
3/9/2021
3/10/2021
3/11/2021
];