topic Re: Just started, difficulty with text format in QlikView

Just started, difficulty with text format

Tue, 20 Aug 2013 00:26:48 GMT

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.

Bryan

Re: Just started, difficulty with text format

Anonymous — Tue, 20 Aug 2013 00:31:33 GMT

Welcome Bryan!

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!

Re: Just started, difficulty with text format

ashwanin — Tue, 20 Aug 2013 05:41:26 GMT

Hi Bryan,

Use your delimiter ~ I/o " . and check the output.

I believe it will help you.

rgds

Ashwani

Re: Just started, difficulty with text format

Tue, 20 Aug 2013 06:16:35 GMT

Hi,

Use the Delimiter as '~' and Quiting as "None". See the attachment.

Re: Just started, difficulty with text format

Tue, 20 Aug 2013 22:41:56 GMT

Hi Ashwani, I'm afraid I'm not sure what that means, where would I put "~ I/o "?

Sorry, quite new to this.

Re: Just started, difficulty with text format

Tue, 20 Aug 2013 22:43:08 GMT

venugopal4s, pardon, not familiar with "Quiting as "None" , I was using the ~~ as my output requires it.

I'm unsure how to use the .qvw file but I am looking into it.

Feeling very in over my head...

Re: Just started, difficulty with text format

Wed, 21 Aug 2013 02:23:07 GMT

Turns out I was including my concatenate on the wrong rule line, once I moved it to the correct line my dataflow worked!

Very excited, thanks for the responses.

Bryan

Re: Just started, difficulty with text format

ashwanin — Wed, 21 Aug 2013 06:18:53 GMT

Hi Bryan,

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.

rgds Ashwani