Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do I Control how QlikView exports data to a txt file?
I have an application where I use the Action, Export on a button. In QV9 this produces a CSV file, but in QV11 I receive a tab separated file.
How can I change this?
//K
I'd forgotten about this Export facility, if it's the one I think you're talking about.
On the Action tab, it looks like you need to go to Setup and then specify the output (Save as) type by using the Browse button.
flipside
Hi
You can add a qualifier to the file type in the store (much like the load):
Store Data into myFile.csv (txt, delimiter is ',')
(Although by default, the files I export are comma separated, and I use '\t' to get a tab separated file)
HTH
Jonathan
I'd forgotten about this Export facility, if it's the one I think you're talking about.
On the Action tab, it looks like you need to go to Setup and then specify the output (Save as) type by using the Browse button.
flipside
Thx, but thats how U do it when using the store function in a script. What I was talking about was eporting from button in the application, a button that the user can use. U add an action (Export) chsoe the filed to e stored and specify the format. In this case MyFile.txt.
//K
Thx, it work and then U change the file extention to .txt if that is what U want.
//K