Discussion board where members can get started with QlikView.
I have a query, and with this result (Table_A)
i want to use it in another query in the script editor.
Is this possible like this.
Select ID_A from AAA;
Select * from BBB
where id in (LOAD ID_A from Table_A);
Or do i have to use a loop:
Get one value from Table_A go through the loop
Store result in Table_B and then get next value of Table_A?
I know it works like this, but i takes a lot of time, because of the big data
Try where exists() function.
Load ID_A as ID
Load ID, * from BBB
you have different possibilities
replace my load * inline with your sql select ....
with keep (tables associated)
load * inline [
left Keep (Table_A) load id as ID_A, val;
with exists (tables associated), see previous answer
with exists (tables not associated)
load * where exists(ID_A, id);