Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Joining multiple residents taking forever

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

1 Solution

Accepted Solutions
Not applicable

Re: Joining multiple residents taking forever

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.

2 Replies
MVP
MVP

Re: Joining multiple residents taking forever

Hi,

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

Regards,

Jagan.

Not applicable

Re: Joining multiple residents taking forever

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.

Community Browser