Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Loading -> Storing ->Relaoding Data

Hello,

I have currently the following Problem. I am loading a set of csv files into qlikview. The load script ist working if I set the following formating string:

FROM
$(CSVFile)
(
txt, codepage is 1252, embedded labels, delimiter is ';', msq);

after some data Manipulation I Export the files with a store Statement, with the following formating:

store

...

from $(y) into '$(varFileFolderExport)/$(y).csv'
(ansi, txt, delimiter is ';', embedded labels);

This is working as well.

But if I try to reimport my exported files then the scripts fails, probably because the Export isnt compliant with the Codepage 1252.

Instead if I Import the files manually qlikview suggest the following Format: (txt, utf8, embedded labels, delimiter is ';', msq);

What do I have to do in order to Export in accordance with the Codepage 1252? Or thus that I finally can reimport my exported data?

Regards,

Matthias

5 Replies
techvarun
Specialist II
Specialist II

Try if the below thread helps

Ansi codification

Anonymous
Not applicable
Author

Hi Varun,

the macro is working if I start it manually it takes some time but I get an exported file in the ansi Format that i can Import using my original script.

But if I call the Sub during the load script like this:

Let vInterfaceFileDirectory='$(varFileFolderExport)\';
Let vInterFaceUTF8FileName='$(y).csv';
Let vInterfaceFileName='$(y)_ANSI.csv';

trace $(vInterfaceFileDirectory);
trace $(vInterFaceUTF8FileName);
trace $(vInterfaceFileName);

Call ConvertInterFaceFileUTF8toANSI();

I am getting an Error in the Call Statement.

With the exact same variables the macro works correct wenn i call it from the ctrl+M window.

Any Ideas?

Thx für the help,

Matthias

techvarun
Specialist II
Specialist II

is it possible to share script and sample data in both 1252 and ansi format?

Anonymous
Not applicable
Author

Hi Varun,

thats quite complicated, since I would have to make up sample data. And as I said the Macro itself is working.

Via trace I checked that the variable values are correct. If I start the macro manually I dont even set the variables manually but just take the ones that remained for the last file from running the script and it works.

So somehow the Problem has to be the Call Statement itself. Do I have to configure qlikview to accept calling macros from the load script?

I have tried the Call with and without ";" at the end.

Regards,

Matthias

marcus_sommer

If your export is only aimed to be imported in Qlik again it would be better to store the data as QVD. Is it aimed to any third-party tools I suggest to check if they could handle the UTF as well before to make more or less expensive convertings on the output.

- Marcus