Joining multiple residents taking forever

Mon, 03 Aug 2015 07:51:28 GMT

Hello,

i think i am doing something wrong.

So basically this is a follow up questions to this thread:

Bar Diagram - Each bar another function

Here was a solution which worked for me - a concatenated table:

ControlNumber:

LOAD personids,

'ControlNumber1' as ControlNumber

RESIDENT TABLE_FROM_FILE1

WHERE hair_color = 'blond';

CONCATENATE (ControlNumber)

LOAD personids,

'ControlNumber2' as ControlNumber

RESIDENT TABLE_FROM_FILE1

WHERE hair_color = 'blond' AND eyes='blue';

So far so good. Now unfortunately, i need to load Value snot only from one Table but from multiple tables.

So basically what i would need is something like this (joining multiple resident tables):

CONCATENATE (ControlNumber)

LOAD personids,

'ControlNumber2' as ControlNumber

RESIDENT T1 JOIN T2

WHERE t1.hair_color = 'blond' AND t2.eyes='blue';

Now i found some solutions but those solutions make my Qlik-View crash.

For instance if i do the following:

tempx:

LOAD

t1.PID

Resident T1;

JOIN(tempx) LOAD

t2.PID

Resident T2;

ControlNumber:

LOAD personids,

'ControlNumber1' as ControlNumber

RESIDENT tempx

WHERE hair_color = 'blond';

CONCATENATE (ControlNumber)

LOAD personids,

'ControlNumber2' as ControlNumber

RESIDENT tempx

WHERE hair_color = 'blond' AND eyes='blue';

Actually i tried out a lot of different ways how to solve this but most of the time my attempts of joining those tables lead to, like i said, Qlik-View crashing. Like i said - i can easily load the contents of one table, but at the moment not sure how to get contents from both tables.

Best Regards,

Daniel

Re: Joining multiple residents taking forever

jagan — Mon, 03 Aug 2015 08:04:27 GMT

Hi,

If you attach sample data and your expected output it would be easier to solve.

Regards,

Jagan.

Re: Joining multiple residents taking forever

Mon, 03 Aug 2015 08:07:23 GMT

Hello,

sorry for bothering - i just fixed it - it seems i had to drop the temp-table after loading it as a resident because it seemed to created circles which made QV crash.

So basically the problem is solved.

topic Re: Joining multiple residents taking forever in QlikView

Joining multiple residents taking forever

Re: Joining multiple residents taking forever

Re: Joining multiple residents taking forever