Data mismatch between tables to be displayed in particular format

[hitha1512]

Hi Team,

Please find below screen shot for the requirement. I have 2 tables and i want the data as per output displayed. 

Table 2 data when compared with Table 1, should give the matching results and data not matching should be displayed as "no data"

Table 1 data when compared with Table 2, should give the matching results and data not matching should be displayed as "no data"

Thank you,

Hitha D

[tresesco · Accepted solution]

May be just a join (full) with composite key. Like:

T1:
Load *,
ID&Item as KEY inline [
ID, Item
1, Red
2, Blue
3, Green
4, Yellow
5, Grey
];
Join
T2:
Load *,
ID&Item2 as KEY inline [
ID, Item2
1, Red
2, Blue
3, Pink
4, Yellow
5, White
];
Drop Field ID;

Then replace the null values.

[hitha1512]

Yes, That works. Thank you:)