Multiple objects

Tue, 29 Mar 2016 19:21:59 GMT

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

topic Multiple objects in QlikView

Multiple objects