Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi,
If you attach sample data and your expected output it would be easier to solve.
Regards,
Jagan.
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.