topic AW:Re: Store into text file with filters in QlikView

Store into text file with filters

Wed, 25 Aug 2010 13:37:11 GMT

Hi!

I need to store some fields from a table into a text file. Do anybody know if it's possible to use filters in the store into statement? I tried this, no error in script but the outcome was not the expected. It was suppose to keep the cells i column 3 (field 3) that contained % and delete the ones that started with 0.

store

field1, field2, field3 from table1 into file.trn
(txt, delimiter is '|', embedded labels, filters(
Remove(Row, RowCnd(CellValue, 3, StrCnd(end, '%', not))),
Remove(Row, RowCnd(CellValue, 3, StrCnd(start, '0')))));

I use version 9.0.7320.7 SR2, can an upgrade solve the problem?

Thanx!

/Kristofer

Store into text file with filters

Miguel_Angel_Baeyens — Wed, 25 Aug 2010 13:48:11 GMT

Hello Kristofer,

You can work around that by creating a new table with the proper field formats, store it and drop it avoiding unneeded syn tables.

ToStoreTemp:LOAD field1, field2, field3 RESIDENT Table WHERE Left(field3, 1) <> 0 AND Index(field3, '%') > 0; STORE ToStoreTemp INTO File.txt (txt); DROP TABLE ToStoreTemp:

Regards.

Store into text file with filters

Wed, 25 Aug 2010 13:57:22 GMT

Hi!

Thanx for your answer.

That's the work around I use in my script now, but if you could use filters in the store into statement you probebly save some loading time if you got large tables.

/Kristofer

Store into text file with filters

Wed, 25 Aug 2010 14:15:46 GMT

Hi!

Another thought could u store files (qvd/txt) without lables?

Exemple:

Field1 | Field 2
1 | a
2 | b
3 | c

Becomes:

1 | a
2 | b
3 | c

/Kristofer

AW:Re: Store into text file with filters

ManuelRühl — Tue, 23 Nov 2010 10:32:05 GMT

this is what i need too!

store into txt without field names.

AW:Re: Store into text file with filters

Tue, 23 Nov 2010 11:02:52 GMT

Try a batch file that strips the header. Like this:


type data.txt | find /V "Field1|Field2" > noheader.txt

-Alex

AW:Re: Store into text file with filters

Miguel_Angel_Baeyens — Tue, 23 Nov 2010 11:20:38 GMT

I'd try this way too, meaning something external to QlikView, since QVD/TXT QlikView stored files use the field names to allow further retrieving of data (as any other database does), and it wouldn't make any sense without them.

Regards.

AW:Re: Store into text file with filters

Tue, 23 Nov 2010 11:30:56 GMT

Hi!

I found this makro by Nimish Shah useful. That solved my problems.

/Kristofer

AW:Re: Store into text file with filters

Tue, 23 Nov 2010 12:44:17 GMT

119 lines of Macro + have Excel installed

versus

one line batch file that does the same