Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Clever_Anjos
Employee
Employee

Square Brackets [] inside an Inline Load

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.

18 Replies
rbecher
MVP
MVP

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

Astrato.io Head of R&D
sunny_talwar

I think this is probably the best one so far.

Clever_Anjos
Employee
Employee
Author

Ralf, your soltutions rocks!

Clever_Anjos
Employee
Employee
Author

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

Kushal_Chawda

Same works with single Quotes too

LOAD * Inline '

F1,F2

,test ';

rbecher
MVP
MVP

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

QlikView Quoteology

Astrato.io Head of R&D
rbecher
MVP
MVP

Oh, I'm rather small.. 🙂

Astrato.io Head of R&D
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.