topic Re: Creating table name with Variable in QlikView

Creating table name with Variable

zagzebski — Fri, 09 Jan 2015 16:47:29 GMT

Basicallty I want to loop through this table giving it a new name by combining "Prod" and the value of i. So it would be Prod1, Prod2, Prod 3, Prod4 and Prod5. How can I add the value of i to "Prod" so I get five sepearate tables?

For i = 1 to 5

Prod:

Select *

Resident PreProd;

Next i

Thanks in advance

Steve

Re: Creating table name with Variable

Fri, 09 Jan 2015 16:53:47 GMT

Just use your counter in the tablename, you will need to use noconcatenate to keep them separate though otherwise as the fields are the same the tables will auto concatenate

For i = 1 to 5

Prod$(i):

Noconcatenate

Load *

Resident PreProd;

Next i

hope that helps

Joe

Re: Creating table name with Variable

marinasbc — Fri, 09 Jan 2015 16:54:35 GMT

Hi,

For i = 1 to 5

Prod$(i):

Select *

Resident PreProd;

Next i

Regards,

Marina

Re: Creating table name with Variable

Anonymous — Fri, 09 Jan 2015 16:59:08 GMT

try this...

qualify *;

for i = 1 to 5

Prod$(i):

load *

resident PreProd;

next i

Re: Creating table name with Variable

zagzebski — Fri, 09 Jan 2015 20:15:51 GMT

Thanks!