Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Karthick30
Creator
Creator

Storing File in (txt, codepage is 28599, embedded labels, delimiter is ',', msq)

Hi ,

   I am using Store command in QlikSense App. by default its stores in UTF-8 format. But I need to store file in this below format

(txt, codepage is 28599, embedded labels, delimiter is ',', msq)

how to achieve this

 

 

Labels (2)
4 Replies
daturpin
Partner - Creator II
Partner - Creator II

What happens when you try:

STORE myTable INTO myFile.txt (txt, codepage is 28599, embedded labels, delimiter is ',', msq)

Those all appear to be valid format specification items

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptSpecifier...

Karthick30
Creator
Creator
Author

@daturpin 

Its not accepting in script editor

Karthick30_0-1693287593223.png

 

daturpin
Partner - Creator II
Partner - Creator II

Hmm.  I'm reading elsewhere that the STORE command may ONLY work with UTF-8 format.

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...

It seems the only acceptable format-spec for STORE is (qvd) or (txt)

Although LOAD and SELECT seem to accept all?

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt...

Sorry, it seems what you want cannot be done, unless there is a plugin I am not seeing.

marcus_sommer

The used windows export-library is quite old and not very powerful/flexible and doesn't support nearly nothing. Therefore you couldn't just apply such store-statement.

But this doesn't mean that you couldn't create the needed output. Thinkable is for example to apply the needed codepage already before - means reading the input with this codepade or transforming the data within the load-statements. In regard to the delimiter you may try to set it and maybe also playing the regional-settings within Qlik and/or the OS. Such step might be skipped by a field-concatenating with the appropriate delimiter in the source which would result in a single output-column. By having any quotes within the data and/or the aim to set extra ones it could become quite difficult and AFAIK not each scenario would be possible - at least not by storing the data from the script-side. But from the UI side it might be possible by looping through a table and writing the content into a csv - at least in QlikView this could be done with vbs-macros. In Sense are such macros not available but there should be further possibilities with the API's.

Before going such way I suggest to check if the csv-target couldn't handle other file-formats, too and/or if an external batch-solution isn't a more practically approach.