topic Re: Store variables in table in load script in QlikView

Store variables in table in load script

Wed, 22 Mar 2017 00:44:03 GMT

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

Re: Store variables in table in load script

Anil_Babu_Samineni — Wed, 22 Mar 2017 04:28:45 GMT

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

Re: Store variables in table in load script

Anonymous — Wed, 22 Mar 2017 04:40:59 GMT

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

Re: Store variables in table in load script

Frank_Hartmann — Wed, 22 Mar 2017 07:33:35 GMT

see attached. hope this helps

Re: Store variables in table in load script

Wed, 22 Mar 2017 10:23:08 GMT

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