topic Re: How to create TXT file from variable? in QlikView

How to create TXT file from variable?

Fri, 07 Aug 2015 10:32:17 GMT

Hello everybody,

my client would like to create TXT file from QlikView with number 0 or 1 (depends on if condition). I was searching for some solution, but I found nothing.

Is it possible to create only file with one of these numbers?

I tried this - but I think it is not good:

LET vNotification_file#1=if( if( InWeek(Today(),date(if( $(vActualDate)<= $(vActualDate2), vActualDate2, vActualDate)),0),

date(date(if( $(vActualDate)<= $(vActualDate2), vActualDate2, vActualDate)))=today(),

date(date(if( $(vActualDate)<= $(vActualDate2), vActualDate2, vActualDate))+2)=today()),

'0 ','1 ');

- then I manually created empty TXT file

Tab1:

LOAD @1 as not1,

$(vNotification_file#1)

from

$(vPathDATA)not.txt

(txt, codepage is 1250, no labels, delimiter is '\t', msq);

Tab2:

LOAD

$(vNotification_file#1)

Resident Tab1;

Store Tab2 into $(vPathDATA)Notification_file#1.txt(txt);

This gives me number 1 in TXT file.

Many thanks.

Maros

Re: How to create TXT file from variable?

Gysbert_Wassenaar — Fri, 07 Aug 2015 13:58:22 GMT

MyTable:

LOAD $(vNotification_file#1) as FieldNameHere

Autogenerate 1;

STORE MyTable into MyFile.txt;

But perhaps this is easier: execute cmd.exe /c echo $(vNotification_file#1) > myfile.txt;

Re: How to create TXT file from variable?

Fri, 07 Aug 2015 14:06:05 GMT

Thanks.

I tried this before - bud it gives me this output:

FieldNameHere

What i need is only this output:

Thank you

Re: How to create TXT file from variable?

Gysbert_Wassenaar — Fri, 07 Aug 2015 14:08:50 GMT

Then use the second option I posted. Saving a table in a text file with the STORE command always (yes, really, really always, no exceptions, I ain't kidding) with a header row that contains the field names.

Re: How to create TXT file from variable?

Fri, 07 Aug 2015 14:24:42 GMT

I was replying to 1st option - "MyTable and STORE". I dont want the header in txt file. I need only value.

The 2nd oprtion - execute is not good for thie solution.

Re: How to create TXT file from variable?

marcus_sommer — Fri, 07 Aug 2015 14:34:22 GMT

Why not the second option?

Re: How to create TXT file from variable?

Sun, 23 Aug 2015 21:55:12 GMT

I tried it with execution, it works. Thanks

Re: How to create TXT file from variable?

carlcimino — Mon, 22 Oct 2018 20:29:50 GMT

How would you do this to a specific location using a variable? I tried the below and it ran but did not produce the file.

LET vDataPath = '\\file path\';

execute cmd.exe /c echo > $(vDataPath)BAR_FILE_IND_TEST.txt (txt);

Re: How to create TXT file from variable?

evan_kurowski — Mon, 22 Oct 2018 20:42:06 GMT

It's always been an item on the wishlist, to be able to have STORE write (txt) verbatim to disk.

Another tricky issue was when contents of the data contained characters like double-quotes, output rows were automatically wrapped with exterior and escaped quotes.

It would be neat to have a pure verbatim STORE option, making it possible to read or form lines of code in script, and output a new valid programmatic file. (Imagine loading, tagging, & re-sequencing XML files or something. course hope this wouldn't get abused)

I upvoted this in IDEA forum

Re: How to create TXT file from variable?

marcus_sommer — Tue, 23 Oct 2018 05:16:03 GMT

There are several issues. Your path contains spaces and needs therefore quotes to be valid. Further you don't use Qlik to store data else you used it to execute the windows command-line to do it (by "abusing" their logging-feature respectively call it a workaround). This means you need to specify also a content and the file musn't have a fileformat entry esle just an extension. This means your code should more look like:

LET vDataPath = '\\file path\';

execute cmd.exe /c echo $(YourFileContent) > "$(vDataPath)BAR_FILE_IND_TEST.txt";

- Marcus

Re: How to create TXT file from variable?

carlcimino — Fri, 26 Oct 2018 15:55:08 GMT

Thanks Marcus. I have it working now. The main problem was the lack of quotes! So silly of me. Appreciate your reminding me of that detail.

execute cmd.exe /c echo. > "$(vDataPath)BAR_FILE_IND.txt";