Compairing two tables

[renjithpl]

Hi,

Can anyone please help me in this as i am new to qlikview. I have a table with different fields given below:

DemoDocID	RelevantCatCode	RelevantCode	ResponCatCode	ResponsiveCode	PrivCode	PotenNoteWorthCode
84403	b	2-NotRelevant	nil	2-NotResponsive	2-NotPrivileged	Nil
79784	c	2-NotRelevant	nil	2-NotResponsive	2-NotPrivileged	Nil
81138	d	2-NotRelevant	nil	2-NotResponsive	2-NotPrivileged	Nil

I want to keep this table as a base in qlikview and compare with an another table with same fields but different values. For example,

Below would be my second table

The DemoDocID would be same..

DemoDocID	RelevantCatCode	RelevantCode	ResponCatCode	ResponsiveCode	PrivCode	PotenNoteWorthCode
84403	a	2-Relevant	nil	nil	2-Privileged	Yes
79784	a	2-Relevant	nil	2-NotResponsive	2-Privileged	Nil
81138	b	2-NotRelevant	nil	2-NotResponsive	2-NotPrivileged

Please help me

[Miguel_Angel_Baeyens]

Hello,

It seems you have a key field (DemoDocID) than can link both tables, so I suggest you to load both tables with different field names except for the DemoDocID field, something like

TableA:LOAD DemoDocID, RelevantCatCode AS RelevantCatCodeA, RelevantCode AS RelevantCodeA,etc

and likewise in table B.

Regards!

[renjithpl]

Thanks a lot, i think you are right..