topic Re: text file is generating but without data? in QlikView

text file is generating but without data?

Fri, 14 Nov 2014 13:46:25 GMT

Hi experts ,

i have a application with in that i have script like after finishing the reload text file need to be generated ,

but i am getting text file without data but my reload is successful, early it is generating but not now ?

what is the reason behind this ?

Re: text file is generating but without data?

Colin-Albert — Fri, 14 Nov 2014 13:50:45 GMT

Have you enabled the option to Generate Logfile?

This should show you how many records and rows are being loaded into your app and should show you why you are seeing no data.

Re: text file is generating but without data?

Fri, 14 Nov 2014 14:01:58 GMT

Hi,

thats already enabled, but i did not required that

i have a comand like

store tablename into ... sales.txt ( i written in script level to store some data in to text file) its working early

but today today it is generating without data what i want to store

ex:

store tablename into ..\sales.qvd and in down i written for one text file(my requirement)

store tablename into ..\sales.txt

Re: text file is generating but without data?

giakoum — Fri, 14 Nov 2014 14:05:05 GMT

store tablename into ..\sales.txt (txt);

try that

is there data in your qvd file?

Re: text file is generating but without data?

Fri, 14 Nov 2014 14:06:21 GMT

syntax is correct only in my script i am getting text file also but without data ?

Re: text file is generating but without data?

Colin-Albert — Fri, 14 Nov 2014 14:06:50 GMT

Have you tried

store tablename into ..\sales.txt (csv) ;

Also does the logfile show that data has been loaded into the table?

Re: text file is generating but without data?

ashfaq_haseeb — Fri, 14 Nov 2014 14:09:23 GMT

Make sure you are not dropping that table before you store it into text.

Regards

ASHFAQ

Re: text file is generating but without data?

kristoferahlin — Fri, 14 Nov 2014 14:16:49 GMT

Have you confirmed in table view (Ctrl + T) that there is data in the relevant table? Just to rule out the possibility that the table was not created correctly...

Re: text file is generating but without data?

Fri, 14 Nov 2014 14:16:52 GMT

i did not droped that table .

just i am getting fieldnames only not inside data.

Re: text file is generating but without data?

giakoum — Fri, 14 Nov 2014 14:21:06 GMT

this cannot happen. please copy the script here.

and please also attach a logfile

Re: text file is generating but without data?

ashfaq_haseeb — Fri, 14 Nov 2014 14:21:27 GMT

Hi,

Can you post your script here

Regards

ASHFAQ