Hi all, first post, I've been using Qlikview just a few days now and I'm close (I think) to getting one of my first hurdles behind me, but the last step or two is driving me nuts.
I need to take disparate flat files with data that looks like this.
SKU
Quantity
123-A
23
123-B
11
123-C
0
And output them into a .txt file that looks like this.
"123-A"~~23.00~~
"123-B"~~11.00~~
"123-C"~~0.00~~
The double tildes are my delimiter and thus far I've only been able to get the output to look like this.
123-A~~23~~
123-B~~11~~
123-C~~0~~
If I could get those quotes and 2 decimal places to output I'd be very thankful.
Your's is the first question post since we went live on upgraded QlikCommunity format this afternoon. Sorry we weren't available for you this weekend. I'm sure you will get some helpful responses soon along with access to great content and resources. Have a good evening!
When you are uploading the txt file or .xlsx file QV will ask you for a delimiter.
there you can put this character . If you are not getting this there then you have to search it's character code there.
If still you get the problem to find it's character code then put this character in msexcel and use formula =char(). It will reflect a number. use same in the qv.
