Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

renjithpl
Valued Contributor

Compairing two tables

Hi,

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

DemoDocIDRelevantCatCodeRelevantCodeResponCatCodeResponsiveCodePrivCodePotenNoteWorthCode
84403b2-NotRelevantnil2-NotResponsive2-NotPrivilegedNil
79784c2-NotRelevantnil2-NotResponsive2-NotPrivilegedNil
81138d2-NotRelevantnil2-NotResponsive2-NotPrivilegedNil

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..

DemoDocIDRelevantCatCodeRelevantCodeResponCatCodeResponsiveCodePrivCodePotenNoteWorthCode
84403a2-Relevantnilnil2-PrivilegedYes
79784a2-Relevantnil2-NotResponsive2-PrivilegedNil
81138b2-NotRelevantnil2-NotResponsive2-NotPrivileged


Please help me

2 Replies

Compairing two tables

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
Valued Contributor

Compairing two tables

Thanks a lot, i think you are right..