topic Re: How to create Pipe Seperate text file in QlikView

How to create Pipe Seperate text file

Tue, 30 Sep 2014 06:17:47 GMT

Hi Forum/Friends,

As we are aware that we can create comm(,) seperate text file by writting the following script in Script Editor:-

Store TABRES into D:\testfilefolder\txtfile.txt(txt);

Note:- Assum that "TABRES" is resident table having 3 columns.

But, I want to create pipe(|) seperate text file. Can anybody show me how to achieve the above requirment?.

Advance Thanks

sushil353 — Tue, 30 Sep 2014 06:26:58 GMT

Hi,

Try this one:

STORE Table into t.csv(delimiter is '|');

hth

sushil

phaneendra_kunc — Tue, 30 Sep 2014 06:29:31 GMT

use this...

Store TABRES into D:\testfilefolder\txtfile.txt (txt, delimiter is '|')

Tue, 30 Sep 2014 07:14:56 GMT

Hi Shan,

Use the following syntax to create Pipe Seperated Text File:-

STORE Population_State_Wise into D:\QlikView\JS API\abc.txt

(delimiter is '|', txt);

Mon, 06 Oct 2014 06:38:22 GMT

Hi Phaneendra/Friends,

Thanks to all for quick response

Thanks & Regards