Expression to show De-tagged resources

[khajafareed]

Hi All,

My Data Souce is Excel, daily we upload excel files and load data into Qlikview.

I have fields like Emp_Code, Emp_name, Prj_Code, Load_Date. Now i want to show the only Emp_name's which are de-tagged/missing from Prj-Code comparing from prvious day excel file and excel file placed Today.

Thanks in Advance.

[felipedl]

Hi Khaja,

Just do a full outter join on both files, loading only Prj_Code and Emp_name for this.

PreviousDay:
Load
Prj_code,
Emp_name,
1 as [Flag Previous Day];
Load * Inline
[
Prj_code,Emp_name
1,A
2,A
3,B
4,D
];


Outer join (PreviousDay)
Load
Prj_code,
Emp_name,
1 as [Flag Current Day];
Load * Inline
[
Prj_code,Emp_name
5,D
2,A
4,C
4,D
];


FinalData:
Load
Prj_code,
Emp_name,
if ([Flag Previous Day]=[Flag Current Day],1,0) as [Flag Days]
Resident PreviousDay;


drop table PreviousDay;

With this code, I get

Which is stating to me that only that Prj_code 2 emp_name A and Prj_code 4 and emp_name D are present in previous and current day file.

[khajafareed]

Thanks for Reply,

But i am not able to get what i required.