topic Re: Looping through columns in table load script in QlikView

Looping through columns in table load script

Anonymous — Fri, 19 Feb 2016 14:28:07 GMT

Hi People,

problem is simple:

I have table with columns names: @1,@2,@3....@10

I want to loop through these columns..

I wrote something like this:

for i= 1 to 10

Table_Name:

load distinct

@$(i) as Parent ( "i" here will be 1)

@$(i)+2 as Kid ( "i" here supposed to be 3)

resident Table2;

next;

This script doesnt work for counting $(i) + 2 as result column name: @3.

How can it be done ?

Thank You in advance for your help,

Jacenk Antek

Re: Looping through columns in table load script

luciancotea — Fri, 19 Feb 2016 17:03:53 GMT

@$(=i+2) as Kid

Re: Looping through columns in table load script

maxgro — Sun, 21 Feb 2016 20:04:46 GMT

for i=1 to 10

let j=$(i)+2;

Table_Name:

load distinct

@$(i) as Parent,

@$(j) as Kid

resident Table2;

next;

Re: Looping through columns in table load script

jagan — Mon, 22 Feb 2016 04:06:14 GMT

Hi,

If it is static number of columns you can simply use below script without making the script more complex to understand

Table_Name:

load distinct

@1 as Parent,

@3 as Kid

resident Table2;

Concatenate(Table_Name)

oad distinct

@2 as Parent,

@4 as Kid

resident Table2;

Re: Looping through columns in table load script

PradeepReddy — Mon, 22 Feb 2016 05:31:14 GMT

if the table contains 10 columns (@1,@2,@3....@10), what is the need to loop the columns?

Mention whatever columns you want load from the resident table (Table2) explicitly..

Table:

Load @1 as Parent1,

@2 as Kid

resident Table2;

Re: Looping through columns in table load script

Anonymous — Mon, 22 Feb 2016 06:57:04 GMT

Hi,

thank you for your answer. Unfortunately this is not working:

error is :

So Kid (Subsetname) is not working - QV doesnt see it as @ and number.

Re: Looping through columns in table load script

Anonymous — Mon, 22 Feb 2016 06:57:20 GMT

thanks! It is working !

Re: Looping through columns in table load script

Anonymous — Mon, 22 Feb 2016 06:57:44 GMT

I wanted to learn somthening new but thx for answer.

Re: Looping through columns in table load script

Anonymous — Mon, 22 Feb 2016 06:59:52 GMT

what if this table had 1000 columns?

Re: Looping through columns in table load script

maxgro — Mon, 22 Feb 2016 10:42:50 GMT

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: Looping through columns in table load script

PradeepReddy — Mon, 22 Feb 2016 11:40:08 GMT

what u want to achieve thru the script?

If you do like this, after all the iterations, you will have two columns only(parent & Kid).

Is this your requirement? If so, my solution is not feasible...

Re: Looping through columns in table load script

Anonymous — Mon, 22 Feb 2016 12:25:34 GMT

Exactly, i wanted to have only 2 columns (parent and kid as hierarchy).

So thank You