Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached qvw for another solution where you will still have the complete tables Master and Table 2.
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;
See attached qvw for another solution where you will still have the complete tables Master and Table 2.
In Sql
Select Name,Date from Master
Minus
Select Name,Date from Table2