I have two files but with different hierarchy.Pls find the below example
File1 File2
Head Dir Mgr Head Dir Mgr
Nikhil Sam Tom Nikhil Sam Tom
Nikhil Sam Brady Nikhil Sam Brady
- - - Nikhil Sam Reece
Paul Mel Lee Paul Mel David
Output:
Head Dir Mgr Diff
Nikhil Sam Tom No diff
Nikhil Sam Brady No diff
Nikhil Sam Reece Diff
Paul Mel Lee Diff
Paul Mel David Diff
file1:
Load *,Autonumber(Head&Dir&Mgr,'Counter') as SNO inline [
Head , Dir , Mgr
Nikhil , Sam , Tom
Nikhil , Sam , Brady
'' , '' , ''
Paul , Mel , Lee ];
Load *, Autonumber(Head&Dir&Mgr,'Counter') as SNO inline [
Head , Dir , Mgr
Nikhil , Sam , Tom
Nikhil , Sam , Brady
Nikhil , Sam , Reece
Paul , Mel , David ];
File3:
Load *,if (Count(SNO)>1,'No Diff','Diff') as Diff
Resident file1
Where len(Head)>0 and len(Dir)>0 and len(Mgr) >0
Group By SNO,Head,Dir,Mgr;
Drop table file1;
Drop Field SNO;
The code is working fine. But now i would like to see now is 1 object that has a list of the difference then if an item is selected from the mismatch list - two objects display to know the data difference
1) the data from the file1
2) the data from the file2
Please help me asap
Thanks
