FieldName() with IterNo()/While?

MarcoWedel — Sun, 31 Aug 2014 18:09:11 GMT

Hi,

given this table:

table1:
LOAD Rand() as Field1,
     Rand() as Field2,
     Rand() as Field3
AutoGenerate 10;

does anybody know, why this code delivers no FieldNames:

tabFields:
LOAD IterNo() as FieldNumber,
     FieldName(IterNo(), 'table1') as FieldName
AutoGenerate 1
While IterNo() <= NoOfFields('table1');

while this does:

FOR i = 1 to NoOfFields('table1')
  tabFields:
  LOAD $(i) as FieldNumber,
      FieldName($(i), 'table1') as FieldName
  AutoGenerate 1;
NEXT i;

thanks for any ideas

regards

Marco

Re: FieldName() with IterNo()/While?

evan_kurowski — Mon, 01 Sep 2014 07:26:30 GMT

I'm only getting results for the FieldName() function when it evaluates once per load statement and not once per row. Maybe it has set-analysis like limitations?

Interesting post Marco, would've expected that first set of syntax to be ok, it seems like you're passing correct parameters.

topic FieldName() with IterNo()/While? in QlikView

FieldName() with IterNo()/While?

Re: FieldName() with IterNo()/While?