Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

inner join is freezing QlikView

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

I can walk on water when it freezes
4 Replies
MK_QSL
MVP
MVP

Are you concatenating or joining the two table?

MayilVahanan

HI

//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;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
christian77
Partner - Specialist
Partner - Specialist

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.

christian77
Partner - Specialist
Partner - Specialist

Hi Dear.

Are you still stalling or you have solved you problem?

How long did it take to reload using mapping?

Salutes.