Comparing two table and getting not matched dates

[yoganantha321]

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

[MarcoWedel]

please post some sample data to test with.

thanks

regards

Marco

[trdandamudi · Accepted solution]

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

[Digvijay_Singh]

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

[Anonymous]

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