Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pradeepm
Contributor II
Contributor II

UnMatching Records to be append

Hi,

I have a table1 having 10 columns & table 2 having 7 columns, where i need to compare 3 fields from both table. If the 3 fields are not matching with the second table 3 fields i need to append 7 columns to my table1. Please tell me if you have any idea..

1 Solution

Accepted Solutions
jagan
MVP
MVP

Hi Pradeep,

Try like this

Data:

LOAD

*,

Dimension1 & '_' & Dimension2 & '_' & Dimension3 AS Key

FROM Table1;

Concatenate(Data)

LOAD

*

FROM Table2

WHERE NOT EXISTS (Key, Dimension1 & '_' & Dimension2 & '_' & Dimension3);

Note: Replace Dimension1, Dimension2 and Dimension3 with your matching fields.

If you want detailed help on this chec Exists() in Qlikview Help file (F1).

Hope this helps you.

Regards,

jagan.

View solution in original post

4 Replies
jagan
MVP
MVP

Hi Pradeep,

Try like this

Data:

LOAD

*,

Dimension1 & '_' & Dimension2 & '_' & Dimension3 AS Key

FROM Table1;

Concatenate(Data)

LOAD

*

FROM Table2

WHERE NOT EXISTS (Key, Dimension1 & '_' & Dimension2 & '_' & Dimension3);

Note: Replace Dimension1, Dimension2 and Dimension3 with your matching fields.

If you want detailed help on this chec Exists() in Qlikview Help file (F1).

Hope this helps you.

Regards,

jagan.

View solution in original post

jyothish8807
Master II
Master II

Hi jagan,

Can you please let me know why you took both (Key, Dimension1 & '_' & Dimension2 & '_' & Dimension3) in NOT EXISTS condition? Both are the same fields?

Regards

KC

Best Regards,
KC
jagan
MVP
MVP

Hi Jyothish,

Key column is the key field in Table1, and Dimension1 & '_' & Dimension2 & '_' & Dimension3 is the key using which we are excluding the already loaded records.


Refer Qlikview Help file (F1) for detailed explanation.

Regards,

Jagan.

jyothish8807
Master II
Master II

Thanks alot Jagan

Regards

KC

Best Regards,
KC