topic Re: Loading -> Storing ->Relaoding Data in QlikView

Loading -> Storing ->Relaoding Data

Anonymous — Fri, 20 Apr 2018 07:41:10 GMT

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

Re: Loading -> Storing ->Relaoding Data

techvarun — Fri, 20 Apr 2018 07:48:32 GMT

Try if the below thread helps

Ansi codification

Re: Loading -> Storing ->Relaoding Data

Anonymous — Fri, 20 Apr 2018 08:44:33 GMT

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

Re: Loading -> Storing ->Relaoding Data

techvarun — Fri, 20 Apr 2018 08:46:41 GMT

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

Re: Loading -> Storing ->Relaoding Data

Anonymous — Fri, 20 Apr 2018 09:05:20 GMT

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

Re: Loading -> Storing ->Relaoding Data

marcus_sommer — Fri, 20 Apr 2018 12:16:08 GMT

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