Storing a qvd file as text file in Qlik Cloud

[PhilippeMotillon]

Hi , 

I try to run that script in QlikSense Cloud 

FOR EACH FlatFile IN FILELIST('[lib://CPAFR:DataFiles/'&'*.qvd');

LET vTable=subfield(SubField('$(FlatFile)','/',4),'.',1);

Trace $(vTable);

Table:
load *
from '$(FlatFile)';

$(vTable):
load RowNo() as RowNo,
*
resident Table;
Store $(vTable) into lib://Dropbox/$(vTable).csv (txt);

Drop Table Table;

NEXT FlatFile;

It works but the format in the file created seems to be xml and not text.

Any idea ?

Thanks 

Philippe

[Benoit_C · Accepted solution]

Hello @Anonymous_motill,

The issue may be with the file extension specified in the Store statement.

Can you try with below statement ?

Store $(vTable) into lib://Dropbox/$(vTable).txt (txt);

See: https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Store.htm

Regards,

Benoit