Resident load from two tables add status as'New'

[woodywup_g]

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'.

[MayilVahanan]

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();