Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you concatenating or joining the two table?
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;
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.
Hi Dear.
Are you still stalling or you have solved you problem?
How long did it take to reload using mapping?
Salutes.