topic Compairing two tables in QlikView

Compairing two tables

renjithpl — Tue, 23 Mar 2010 06:56:55 GMT

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

Compairing two tables

Miguel_Angel_Baeyens — Tue, 23 Mar 2010 09:09:27 GMT

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!

Compairing two tables

renjithpl — Tue, 23 Mar 2010 10:24:18 GMT

Thanks a lot, i think you are right..