Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Store variables in table in load script

Here is a sample file that uses a loop to create variables.  Now I need to to store the created variables in a table, and clear or delete the variables after the table is created.  Any help would be appreciated.

See attached sample

4 Replies

Re: Store variables in table in load script

What are trying to do over here, Would you post on Wall

laddu_927
Valued Contributor

Re: Store variables in table in load script

Am not sure what you are expecting exactly. But based on my understanding implemented the attached. Let us know if you need something different.

franky_h79
Honored Contributor

Re: Store variables in table in load script

see attached. hope this helps

Not applicable

Re: Store variables in table in load script

Thanks guys, not quite there.

What I’m trying to do is assign multiple variables from a table, like what’s in my original file; so that’s the first part.  The second part is when I have those 3 variables in a table, I want to use them in the scrip to alias fields.  So I would end up a field1 as A, field2 as B, field3 as C.  When the load stops, I want to have field names as 1, 2, 3 and then if possible I want to remove the variables A, B, C from the system. 

This is just a test. What I’m really doing is working with an AS400 library, and I need to rename the fields is many tables.

Thanks