Compare Date

[jyothish8807]

Hi All,

i have two table Master and table 2.

master table contains all the possible dates corresponding to a name.

Table 2 contain dates corresponding to same name, but the dates in this table may be different from the dates in master table.

Now i want to compare table 2 with master table and track all the dates which are not present in table 2 but present in master table,

Master:

Name Date

A        Jan 2010

A        Feb 2010

A        Mar 2010

A        Apr 2010

B        Jan 2011

B        Feb 2011

B        Mar 2011

Table 2:

Name   Date1

A      Jan 2010

A      Mar 2010

A      Apr 2010

A      May 2010

B     Jan 2011

Now in table 2 for A Feb 2010 is missing, so i want to track that.and for B Feb 2011 and Mar 2011 is missing, so want to track that also.

Regards

Jyothish KC

[swuehl]

Try like this:

Table2:

LOAD *, Name&Date1 as Key INLINE [

Name,   Date1

A,      Jan 2010

A,      Mar 2010

A,      Apr 2010

A,      May 2010

B,     Jan 2011

];

Master:

LOAD * INLINE [

Name, Date

A,        Jan 2010

A,        Feb 2010

A,        Mar 2010

A,        Apr 2010

B,        Jan 2011

B,        Feb 2011

B,        Mar 2011

] where not exists (Key, Name&Date);

drop table Table2;

[Gysbert_Wassenaar · Accepted solution]

See attached qvw for another solution where you will still have the complete tables Master and Table 2.

[anbu1984]

In Sql

Select Name,Date from Master

Minus

Select Name,Date from Table2