topic using loop FOR EACH ... NEXT in QlikView

using loop FOR EACH ... NEXT

justinasp — Tue, 16 Mar 2010 12:39:13 GMT

Hello all,

I need to join tables from active tables list. Please see the code below:

Table1=1;
Table2=1;
Table3=0;
IF Table1=1 THEN
NOCONCATENATE
TABLE1:
LOAD * INLINE
[
 VAR1, VAR2, VAR3
 A, 1, X
 B, 2, X
];
ENDIF
IF Table2=1 THEN
NOCONCATENATE
TABLE2:
LOAD * INLINE
[
 VAR1, VAR2, VAR4
 C, 3, Y
 D, 2, Z
];
ENDIF
IF Table3=1 THEN
NOCONCATENATE
TABLE3:
LOAD * INLINE
[
 VAR1, VAR2, VAR3
 E, 1, 0
 F, 4, X
];
ENDIF
InTable:
LOAD IF(TableName=1,TableID) as Table
INLINE
 [
 TableName, TableID

 $(Table1), TABLE1
 $(Table2), TABLE2
 $(Table3), TABLE3
 ];
FOR EACH vTable IN {"Need to take $(Table) from InTable"}
ActiveList:
LOAD VAR1,
 VAR2
RESIDENT $(vTable);
DROP TABLE $(vTable);
NEXT vTable;

Thank's for any reply,

Justinas

using loop FOR EACH ... NEXT

Tue, 16 Mar 2010 13:52:15 GMT

Use PEEK(). [Schemas]: LOAD * INLINE [ SCHEMANAME, SCHEMATABLES SIS001, "('SCHEMA001','SCHEMA002')" SIS002, "('SCHEMA001','SCHEMA003')" ]; [t_Schemas]: LOAD recno() as SCHEMACOUNT RESIDENT [Schemas]; let count = 1; let schemaCount = peek('SCHEMACOUNT',-1,[t_Schemas]); drop table [t_Schemas]; do while count

using loop FOR EACH ... NEXT

justinasp — Tue, 16 Mar 2010 15:05:08 GMT

Hi, Fabio,

I'm not sure if I got your mind or your solution is not, what I am looking for this time.

My issue is to use field value from the Inline table as a variable in a loop.

using loop FOR EACH ... NEXT

rwunderlich — Wed, 17 Mar 2010 07:55:20 GMT

I'm not understanding exactly what you are rying to accomplish, biut a suggeted syntax may be:

FOR i = 0 TO NoOfRows('InTable') - 1
LET vTable = peek('TableID', $(i), 'InTable')

LOAD VAR1,
VAR2
RESIDENT $(vTable);
DROP TABLE $(vTable);
NEXT i

-Rob

using loop FOR EACH ... NEXT

justinasp — Wed, 17 Mar 2010 11:28:42 GMT

It was just a peace of the big view, but you leaded me to the right direction. Thank's for your help, Rob.