Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gidon500
Creator II
Creator II

Store table in script without header

Hi guy 

I have used a recommendation from the forum  how to store a table

in script  .

I have a problem that I do not know how to continue 

I get an error of unique key , buy I do not use header it is only data to store .

I do not know how to continue from this point  I just want to store data no headers required 

enclosed in a sample from my document 

thanks for the help 

gidon

 

4 Replies
Gysbert_Wassenaar

Your idea is good, but you have the bad luck that the first line of your table has two fields that have the same value:

 1, D100, 100, 100, 77

Since field names have to be unique in a table you can't create a table with two fields named 100.

So, choose another row to use as header that doesn't have fields with the same values. See attached qvw

 


talk is cheap, supply exceeds demand
gidon500
Creator II
Creator II
Author

Hi Gysbert 

the store command is in a loop 

and in many of the store action it will be only one line 

there  is no way to tell the Qlik that this table is only data  without  lable  or key

I only need to store the data and than move to next  file to store .

I have to do it in a script  loop .

any way to do it  .

gidon

 

 

 

 

 

 

 

gidon500
Creator II
Creator II
Author

Hi Gysbert 

One more question 

is it possible to run macro in script ? 

thanks

gidon

 

Gysbert_Wassenaar

Yes, some macro's can be run in the script. But you're probably better of with an external script that you execute from the load script using the EXECUTE command. See the online help page: https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Sc...

talk is cheap, supply exceeds demand