topic Re: Comparing two table and getting not matched dates in QlikView

Comparing two table and getting not matched dates

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

I have a two tables as follows:

table 1:( I have filter one employeeID)

table 2:( I have filter one employeeID)

I want to compare the two dates and I wanted the not matched dates from table1 with table2. As below highlighted

I want the dates 01/01/2017, 01/08/2017, 01/14/2017,01/15/2017 and 01/16/2017 in another table or creating a flag like think for identification..........

I cannot share the documents......... Sorry for the inconvenience.

Regards

Yoganantha Prakash G P

Re: Comparing two table and getting not matched dates

MarcoWedel — Thu, 04 May 2017 20:06:55 GMT

please post some sample data to test with.

thanks

regards

Marco

Re: Comparing two table and getting not matched dates

trdandamudi — Thu, 04 May 2017 20:16:58 GMT

I did a quick sample code based on your logic as below:

Table2:
Load * Inline [
EmployeeID,Date,worked_hours,FName
138,01/02/2017,8.30,Prakash
138,01/03/2017,8,Prakash
];

NoConcatenate
Table1:
Load *
Where Not Exists(Date);

Load * Inline [
EmployeeID,Date,FName
138,01/01/2017,Prakash
138,01/02/2017,Prakash
];

Drop Table Table2;

Hope this helps...

Re: Comparing two table and getting not matched dates

Digvijay_Singh — Thu, 04 May 2017 20:41:31 GMT

The field name of both date fields is same or different in your data model?

Re: Comparing two table and getting not matched dates

Anonymous — Thu, 04 May 2017 21:44:27 GMT

If you want to keep all the data in your data model and you can make your first table a straight table, maybe you could try something like this:

sum({<Date= e({<sheet_date= {"*"} >} ) >} Rowno())