topic Re: Store table in script without header in QlikView

Store table in script without header

gidon500 — Wed, 25 Nov 2020 16:16:04 GMT

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

Gysbert_Wassenaar — Sun, 18 Nov 2018 15:11:09 GMT

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

gidon500 — Sun, 18 Nov 2018 15:29:19 GMT

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 — Sun, 18 Nov 2018 16:04:10 GMT

Hi Gysbert

One more question

is it possible to run macro in script ?

thanks

gidon

Gysbert_Wassenaar — Sun, 18 Nov 2018 17:48:52 GMT

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/ScriptRegularStatements/Execute.htm