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.
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.
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.
