topic Generation of txt file from the script in App Development

Generation of txt file from the script

JaMajka1 — Tue, 26 Jul 2016 08:06:32 GMT

Hello experts,

could you help me with one issue, please? I want to generate .txt file from the script during the load (in QlikSense). I created a new internal table using by LOAD * INLINE and the generation of .txt file was successful. The issue is that in the file there is a lot of rows named as QvdTableHeader which I do not need and I do not want in the file.

Thank you for any advice,

Maria

Re: Generation of txt file from the script

Anonymous — Tue, 26 Jul 2016 08:32:08 GMT

Hey Mária,

Editing the table is not possible when using the Store command (the table can only be saved with the same data as the internal table). This means you have to make the necessary changes to the table as part of the LOAD command. It sound like you might have an error in your Store statement. Make sure it is of the form:

Store [mytable] into [myfile].txt (txt);

and NOT something like:

Store * into [myfile].txt (txt);

If this doesn't help, please share your script for loading and storing the table.

Re: Generation of txt file from the script

JaMajka1 — Tue, 26 Jul 2016 09:01:51 GMT

Hey Henri,

the generation of .txt is okey. The file has been created. It just has a long header in the beggining, so there is no error here.

The script is:

SET vParameter = 2;

Premenna:

Load * INLINE [

Hodnota

$(vParameter)

];

STORE Premenna INTO [lib://tabulecka.txt];

In the meanwhile I have found the solution... there should be added " (txt) " in the end. So the last row should be:

STORE Premenna INTO [lib://tabulecka.txt](txt);

You also wrote it in that way .

Thank you,

Maria

Re: Generation of txt file from the script

Anonymous — Tue, 26 Jul 2016 12:08:11 GMT

Glad you found the solution!