Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone , need help on Qliksense loading editer.
I got table case to be loaded every day from excel file into Qliksense. same table structure
[today_case]:
Load case_id , case_date , stage from case.xlsx where case_date =today();
[yesterday_case]
Load case_id , case_date , stage from case.xlsx where case_date =today()-1;
how can I Resident join loaded [yesterday_case] add case_id which is new in [today_case] and need mark the stage as 'NEW'.
Hi @woodywup_g
Try like below
[yesterday_case]
Load case_id , case_date , stage from case.xlsx where case_date =today()-1;
[today_case]:
Load case_id , case_date , if(Exists(case_id), 'Exist', 'NEW') as stage from case.xlsx where case_date =today();