Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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