Square Brackets [] inside an Inline Load

[Clever_Anjos]

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.

[rbecher · Accepted solution]

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

[sunny_talwar]

I think this is probably the best one so far.

[Clever_Anjos]

Ralf, your soltutions rocks!

[Clever_Anjos]

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

[Kushal_Chawda]

Same works with single Quotes too

LOAD * Inline '

F1,F2

,test ';

[rbecher]

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

QlikView Quoteology

[rbecher]

Oh, I'm rather small.. 🙂

[Kushal_Chawda]

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

[sunny_talwar]

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