Discussion Board for collaboration on QlikView Scripting.
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:
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?
Go to Solution.
here is the file Qvw with the solution,
I wait help
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
Try the below code .
If consider your Table name as TableData .
Load Distinct A as TxtFilename resident TableData;
For i=0 to j step 1
let s=Peek('TxtFilename',i,'ColumnList') ;
Load * resident TableData
where A='$(s)' ;
Store tab into path/$(s).txt .
Drop table Tab;
Please reply me for the same.
Thank You, it works perfectly.