topic Re: Cannot store data into csv? in QlikView

Cannot store data into csv?

vchuprina — Mon, 02 Mar 2015 12:06:33 GMT

Hi,

Parser work correctly without errors, but doesn't store data into csv file.

This problem appeare today, long time before parser save data.

What the cause of this problem?

Maybe someone had a similar problem?

Re: Cannot store data into csv?

simospa — Mon, 02 Mar 2015 12:12:35 GMT

Hi,

can you delete .csv file? If no, there could be a qv process that blocks the file.

Try to close QV and reopen.

Re: Cannot store data into csv?

vchuprina — Mon, 02 Mar 2015 12:16:39 GMT

Hi Simone,

I don't have .csv file

Re: Cannot store data into csv?

simospa — Mon, 02 Mar 2015 12:19:20 GMT

Ok,

try to post a snippet of your code.

Re: Cannot store data into csv?

vchuprina — Mon, 02 Mar 2015 12:23:04 GMT

Store part of script:

STORE FinalOutput INTO Data\Current\Output_N.csv (txt);

Re: Cannot store data into csv?

simospa — Mon, 02 Mar 2015 12:30:33 GMT

Verify the path, it works.

Try to insert complete path (C:\....\Data|Current\Outpur_N.csv (txt)

Re: Cannot store data into csv?

vchuprina — Mon, 02 Mar 2015 12:52:06 GMT

I have tried this, but it is not work.

After running script, appear window where I can select which fields will be visible in the application.

Re: Cannot store data into csv?

p_verkooijen — Mon, 02 Mar 2015 12:58:46 GMT

If you get the select field window, the reload has succeeded without error.

So the store into should have worked, maybe you mean that the csv is not a ; delimited file but the default ,

When you just use STORE table INTO filename.csv (txt,delimiter is ';') you get a ; delimited file alongside the QlikView document.

Re: Cannot store data into csv?

avinashelite — Mon, 02 Mar 2015 13:01:08 GMT

check that space in your sever or the space in path where your storing the data i.e. csv files .

Re: Cannot store data into csv?

vchuprina — Mon, 02 Mar 2015 13:20:34 GMT

I get select field window only for this files.

Problem that i don't have any output file.

Re: Cannot store data into csv?

p_verkooijen — Mon, 02 Mar 2015 13:31:39 GMT

As I mentioned earlier, If you get the select field window, the reload has succeeded without error.

This is the default after a reload.

When you use STORE INTO, the file is stored in the background. There won't be any popup after the reload,