topic Re: Inline view with Pipeline Delimeter in QlikView

Inline view with Pipeline Delimeter

Mon, 02 Dec 2013 14:53:45 GMT

How can I make it possible to create an inline view with pipeline delimited ?

//-------------------------------------------

INLINE:

Load * Inline

[

ENAME|SAL

SCOTT|800

SMITH|900

KIND|600

];

//-------------------------------------------

But this is not working as expected..

Re: Inline view with Pipeline Delimeter

Anonymous — Mon, 02 Dec 2013 15:08:57 GMT

Wondering - what prevents replacing pipe with comma? It can be done in a few clicks

Re: Inline view with Pipeline Delimeter

richard_pearce6 — Mon, 02 Dec 2013 15:11:27 GMT

I don't think that it's possible. You can set the delimiter on imports such as csv files so you could load your data from there. The simplest option (unless you have commas in the data field values) would be to use search and replace to change the pipes back to commas so you can use an inline load.

Re: Inline view with Pipeline Delimeter

richard_pearce6 — Mon, 02 Dec 2013 15:14:05 GMT

If you have commas in the data you have to use " " around the field value

Re: Inline view with Pipeline Delimeter

rbecher — Mon, 02 Dec 2013 15:21:55 GMT

Hi, Consultant,

I just tried for the sake of curiosity and it worked:

INLINE:
Load * Inline
[
ENAME|SAL
SCOTT|800
SMITH|900
KIND|600
] 
(ansi, txt, delimiter is '|', embedded labels)
;

- Ralf

Re: Inline view with Pipeline Delimeter

Tue, 03 Dec 2013 09:29:01 GMT

Kudos Ralf . Many Thanks to you.

Re: Inline view with Pipeline Delimeter

Tue, 03 Dec 2013 09:30:15 GMT

I am handling that 'Unless Scenario' only Richard.. Thanks for your Understanding ..

Re: Inline view with Pipeline Delimeter

rbecher — Tue, 03 Dec 2013 09:31:06 GMT

It just follows the LOAD syntax.. But, please mark it as answered then. It will help others to find it.

Re: Inline view with Pipeline Delimeter

rbecher — Tue, 03 Dec 2013 09:33:27 GMT

I understand you requirement. It's much more easier to just copy / paste the data..