loop through a table and load another by ID

Mon, 29 Nov 2010 11:59:45 GMT

Hi all,

could be that I have forgitten everything, but I am stuck with that Problem:

I Load a "Header" Table form the Database. In that table there is a ID wich is FK in an other table with details.

I cant load the whole detail table because thats too many records.

So I want to LOOP throgh the header Table and select all detail records for every ID.

In exaple:


Header:
LOAD ID;
Select ID from header_table;

for each ID in Header
Detail:
LOAD <All Fields>;
Select * from Detail_table where FK_ID = ID;
LOOP;

Thanks in advance

Alex

topic loop through a table and load another by ID in QlikView