Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.