Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I combine two inline tables(startDate + peakDate) into one new table(workDate) in qliksense script?
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
];
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
];