topic Re: Use FieldName((IterNo(), ..) in a Load statement in QlikView

Use FieldName((IterNo(), ..) in a Load statement

Tue, 08 Apr 2014 22:13:54 GMT

Hi, what do I do wrong? ...

Thanks,

Shaul

unQUALIFY *;

Facts:

LOAD * INLINE [

FactA, FactB, FactC

100, 200, 300

];

Set vTableName = 'Facts';

Let vNoOfFields = NoOfFields(vTableName);

trace vTableName= $(vTableName);

trace vNoOfFields $(vNoOfFields);

Let vFieldName1 = FieldName(1, vTableName);

Let vFieldName2 = FieldName(2, vTableName);

Let vFieldName3 = FieldName(3, vTableName);

Trace vFieldName1 = $(vFieldName1);

Trace vFieldName2 = $(vFieldName2);

Trace vFieldName3 = $(vFieldName3);

nullasvalue *;

Set NullValue = 'FieldName() Failed!!' ;

QUALIFY *;

LOAD

Iterno() As ROW_ID

,FieldName((Iterno()), '$(vTableName)') as [FieldName]

,FieldName(1, '$(vTableName)') as [FieldName_test1]

,FieldName(2, '$(vTableName)') as [FieldName_test2]

,FieldName(3, '$(vTableName)') as [FieldName_test3]

AutoGenerate 1 While IterNo() <= $(vNoOfFields)

;

Re: Use FieldName((IterNo(), ..) in a Load statement

whiteline — Wed, 09 Apr 2014 06:15:22 GMT

Hi.

IterNo() is applicable for while statements.

For autogenerate use RowNo().

Re: Use FieldName((IterNo(), ..) in a Load statement

sujeetsingh — Wed, 09 Apr 2014 06:24:22 GMT

Go for RecNo() or Autohash

Re: Use FieldName((IterNo(), ..) in a Load statement

Wed, 09 Apr 2014 14:33:03 GMT

Hi,

Indeed I use the while statement (see provided code snippet above). When referencing the IterNo() as a column, it populates correctly, yet when being used inside the the FieldName() function it cases it to fail. it seems as the same behavior occurs when using RecNo(), RowNo(), and AutoNumberHash().

Could you please provide code snippet that actually work?

Thanks!

Re: Use FieldName((IterNo(), ..) in a Load statement

whiteline — Wed, 09 Apr 2014 19:21:22 GMT

Ah... Sorry.

Strange, seems like IterNo()/RowNo() is not actually a regular function.

Ok, the only way I've found is manual loop:

//QUALIFY *;

for i=1 to $(vNoOfFields)

LOAD

$(i) As ROW_ID

,FieldName($(i), '$(vTableName)') as [FieldName]

,FieldName(1, '$(vTableName)') as [FieldName_test1]

,FieldName(2, '$(vTableName)') as [FieldName_test2]

,FieldName(3, '$(vTableName)') as [FieldName_test3]

AutoGenerate 1;

next i;

Re: Use FieldName((IterNo(), ..) in a Load statement

Thu, 10 Apr 2014 01:03:37 GMT

Well,

I would consider it a ‘non-documented-feature.. ’, but nevertheless, your workaround work just fine.

Thanks for your help!

Regards,

Shaul