topic Re: Dynamic Field Name in Load Script in QlikView

Dynamic Field Name in Load Script

Anonymous — Tue, 06 Oct 2015 10:37:54 GMT

Hi I have a question,

I have to data source, let's say.

SourceA

SourceA has field like this,

W1 W2 W3 until ........................... W100

........

I want to load data from SourceA without naming each field one by one

is it possible to loop the field name

So it will be

Load

Loop var from 1 to 100

W+var

FROM....

Re: Dynamic Field Name in Load Script

sunny_talwar — Tue, 06 Oct 2015 12:24:17 GMT

May be try it with RowNo() or RecNo():

LOAD W & RowNo() as SourceA

Re: Dynamic Field Name in Load Script

sunny_talwar — Tue, 06 Oct 2015 12:25:02 GMT

Re: Dynamic Field Name in Load Script

Clever_Anjos — Tue, 06 Oct 2015 13:07:34 GMT

table:
load null() as n AutoGenerate 0;

for i = 1 to 100
Concatenate(table)
  LOAD
  'W$(i)' as W$(i)  // Remove quotes when loading from your source

   autogenerate 1;
next
drop Field n;

Re: Dynamic Field Name in Load Script

cwolf — Tue, 06 Oct 2015 19:39:51 GMT

Create a variable with the fieldnames:

set vFieldNames='';

for i=1 to 100

let vFieldNames='$(vFieldNames)' & 'W$(i)' & if($(i)<100,',');

next i;

LOAD

$(vFieldNames)

From ...

Re: Dynamic Field Name in Load Script

maxgro — Tue, 06 Oct 2015 19:51:34 GMT

load Concat(f, ', ', id) as f;

load recno() as id, 'w' & recno() as f AutoGenerate 100;

let v=peek('f');

table:

load $(v)

From somefile;

Re: Dynamic Field Name in Load Script

Thu, 20 Oct 2016 13:07:34 GMT

what is this load null() ... autogenerate and drop Field magic ? .. without it the script is a whole Error?

Please explain...

Thank you!

Re: Dynamic Field Name in Load Script

Clever_Anjos — Thu, 20 Oct 2016 16:44:12 GMT

The purpose is to create a "stub" table so "Concatenate (table)" would not fail in the very first loop step