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 [ startDate3/4/20213/5/20213/8/20213/10/20213/14/20213/15/20213/16/20213/20/20213/21/20213/23/20213/24/2021];
peakDate:load * Inline [ peakDate3/5/20213/9/20213/10/20213/11/2021];
Try this:
DateTable:load startDate, startDate as workDate Inline [ startDate3/4/20213/5/20213/8/20213/10/20213/14/20213/15/20213/16/20213/20/20213/21/20213/23/20213/24/2021];
join (DateTable)load peakDate, peakDate as workDate Inline [peakDate3/5/20213/9/20213/10/20213/11/2021];