topic Square Brackets [] inside an Inline Load in QlikView

Square Brackets [] inside an Inline Load

Clever_Anjos — Tue, 05 Jan 2016 19:40:47 GMT

I´d like to know why a simple script like that causes an error

LOAD * INLINE [
    F1, F2
    "", test
];

I know I can do this

LOAD Replace(Replace(F1,'{','['),'}',']') as F1, F2 INLINE [
    F1, F2
    "{a}", test
];

I´d like to know if there´s an easier way of doing this.

Re: Square Brackets [] inside an Inline Load

sunny_talwar — Tue, 05 Jan 2016 19:51:55 GMT

Don't know why, but this seems to work:

LOAD * INLINE [

F1, F2

], test

];

Re: Square Brackets [] inside an Inline Load

Clever_Anjos — Tue, 05 Jan 2016 20:31:14 GMT

But this does not

LOAD F1, F2 INLINE [

F1, F2

"]", test

];

Re: Square Brackets [] inside an Inline Load

Clever_Anjos — Tue, 05 Jan 2016 20:31:51 GMT

Anyway, one more silly point

Re: Square Brackets [] inside an Inline Load

sunny_talwar — Tue, 05 Jan 2016 20:35:12 GMT

This worked because two square brackets formed escape sequence: Escape sequences

Re: Square Brackets [] inside an Inline Load

maxgro — Tue, 05 Jan 2016 20:37:51 GMT

SET ErrorMode=0;

LOAD F1, F2 INLINE [

F1, F2

"]", test

"]", test

];

SET ErrorMode=1;

Re: Square Brackets [] inside an Inline Load

Clever_Anjos — Tue, 05 Jan 2016 20:44:07 GMT

maxgro‌, using QV 12

Re: Square Brackets [] inside an Inline Load

sunny_talwar — Tue, 05 Jan 2016 20:47:12 GMT

That's what I got too....

Somehow this ->

LOAD * INLINE [

F1, F2

], test

];

is also creating issues for script after this load.

Re: Square Brackets [] inside an Inline Load

sunny_talwar — Tue, 05 Jan 2016 20:51:21 GMT

Oh well, although the script editor doesn't understand it, the script still runs without issue:

LOAD * INLINE [

F1, F2

], test

];

Table:

LOAD * Inline [

Field

];

Re: Square Brackets [] inside an Inline Load

maxgro — Tue, 05 Jan 2016 20:52:32 GMT

I'm on 11.20. Not a good thing the result is so different 11 vs 12.

Re: Square Brackets [] inside an Inline Load

rbecher — Tue, 05 Jan 2016 20:55:07 GMT

Hi all,

there is another more simple solution with quotes (esp. if you want to paste lots of data from wherever):

LOAD * INLINE "

F1, F2

, test

- Ralf

Re: Square Brackets [] inside an Inline Load

sunny_talwar — Tue, 05 Jan 2016 20:58:09 GMT

I think this is probably the best one so far.

Re: Square Brackets [] inside an Inline Load

Clever_Anjos — Wed, 06 Jan 2016 11:14:07 GMT

Ralf, your soltutions rocks!

Re: Square Brackets [] inside an Inline Load

Clever_Anjos — Wed, 06 Jan 2016 11:20:56 GMT

"Standing on the shoulders of giants", sunindia‌, rbecher‌, maxgro‌

Re: Square Brackets [] inside an Inline Load

Kushal_Chawda — Wed, 06 Jan 2016 11:44:35 GMT

Same works with single Quotes too

LOAD * Inline '

F1,F2

,test ';

Re: Square Brackets [] inside an Inline Load

rbecher — Wed, 06 Jan 2016 12:09:32 GMT

Well, you're right. It's just a matter of qouting. Nothing complex..

QlikView Quoteology

Re: Square Brackets [] inside an Inline Load

rbecher — Wed, 06 Jan 2016 12:12:31 GMT

Oh, I'm rather small.. 🙂

Re: Square Brackets [] inside an Inline Load

Kushal_Chawda — Wed, 06 Jan 2016 12:13:36 GMT

Yes, you are right. It was just my curiosity to check with single quote

Re: Square Brackets [] inside an Inline Load

sunny_talwar — Wed, 06 Jan 2016 12:27:39 GMT

Oh you guys are huge... My name with elite such as yourself is a huge honor for someone like me.