topic Re: inner join is freezing QlikView in QlikView

inner join is freezing QlikView

ali_hijazi — Wed, 04 Dec 2013 15:46:37 GMT

Dear

I got two tables with a Key in common

the relation is one to one

I'm trying to join the two tables but QlikView simply stalls ; I waited for 2 hours and nothing happens just STALL!!

Please check the attached sample data

I commented the script which makes the inner join

OK I can leave the tables linked but I'm wondering why QlikView stalls after making the inner join on these two tables

you may tell me that the number of columns is big but I tried to have only 2 columns from each table and the same thing happens no change

Please advise

Re: inner join is freezing QlikView

MK_QSL — Wed, 04 Dec 2013 15:50:32 GMT

Are you concatenating or joining the two table?

Re: inner join is freezing QlikView

MayilVahanan — Wed, 04 Dec 2013 16:00:03 GMT

//inner join(Question)

//LOAD * Resident Question_Type;

//drop Table Question_Type;

In your script, you didn't mention Question and Question_Type Table name.

Try like this

Question:

LOAD AzadeaID & '|' & Country & '|' & Effective_Date as Key,

Question_28,

Question_25,

Question_22,

Question_21,

Question_20,

Question_19,

Question_18,

Question_17,

Question_12,

Question_27,

Question_26,

Question_24,

Question_23,

Question_16,

Question_15,

Question_14,

Question_13,

Question_11,

Question_10,

Question_9

FROM

Question.qvd

(qvd);

Question_Type:

LOAD AzadeaID & '|' & Country & '|' & Effective_Date as Key,

Question_Type_28,

Question_Type_25,

Question_Type_22,

Question_Type_21,

Question_Type_20,

Question_Type_19,

Question_Type_18,

Question_Type_17,

Question_Type_12,

Question_Type_27,

Question_Type_26,

Question_Type_24,

Question_Type_23,

Question_Type_16,

Question_Type_15,

Question_Type_14,

Question_Type_13,

Question_Type_11,

Question_Type_10,

Question_Type_9

FROM

Question_Type.qvd

(qvd);

inner join(Question)

LOAD * Resident Question_Type;

drop Table Question_Type;

Re: inner join is freezing QlikView

christian77 — Wed, 04 Dec 2013 16:08:45 GMT

Hi Ali.

A workarround for joins is using mapping.

See the example. I hope the mapping is well done. You must check your records to be the right ones.

It is not as fast as no joinning but it is much faster tan freezing.

Good luck.

Re: inner join is freezing QlikView

christian77 — Tue, 17 Dec 2013 09:42:21 GMT

Hi Dear.

Are you still stalling or you have solved you problem?

How long did it take to reload using mapping?

Salutes.