topic Re: store Data in different files in QlikView

store Data in different files

khag_hs — Wed, 17 Apr 2013 15:19:00 GMT

Hi,

I have a table like this:

Now I want to export the content of the table in different txt-files:

Each Data with the same content in colume A should be stored into the same txt-file.

In my example I shoud get three txt-files:

1001.txt

1002.txt

1003.txt

For example, file 1001.txt shoud have the following content:

A B C

1001 1,1 2,0

1001 1,2 3,0

Can anyone help me?

alexandros17 — Wed, 17 Apr 2013 15:27:59 GMT

You have to replicate the same logic of your table to make queries to store data.

If you provide the example I'll help you

Wed, 17 Apr 2013 15:53:02 GMT

Hi ,

Try the below code .

If consider your Table name as TableData .

ColumnList:

Load Distinct A as TxtFilename resident TableData;

Let j=NoOfrows('ColumnList')-1;

For i=0 to j step 1

let s=Peek('TxtFilename',i,'ColumnList') ;

noconcatenate

Tab:

Load * resident TableData

where A='$(s)' ;

Store tab into path/$(s).txt .

Drop table Tab;

Please reply me for the same.

//yusuf

Anonymous — Wed, 17 Apr 2013 16:26:48 GMT

Hello Khag,

here is the file Qvw with the solution,

I wait help

khag_hs — Thu, 18 Apr 2013 08:40:11 GMT

Thank You, it works perfectly.