topic Re: How can I load inline a value that contains a QV-script-reserved character? in QlikView

How can I load inline a value that contains a QV-script-reserved character?

Mon, 19 Dec 2011 09:42:32 GMT

Hi,

I am trying to load inline, but one of the values that I want to load contains the character "]" which is QV-script-reserved. The value is:

CYCLADES]

Do you see? It contains the "]". This conflicts with the LOAD * INLINE [ ... ]; syntax.

Any clue?

Thanks in advance

Panayotis

How can I load inline a value that contains a QV-script-reserved character?

vijay_iitkgp — Mon, 19 Dec 2011 11:25:15 GMT

Hi Panayotis,

You can use Excel spreadsheet as work around

Regards

Vijay

How can I load inline a value that contains a QV-script-reserved character?

Mon, 19 Dec 2011 11:30:51 GMT

Hmmmm. I marked your answer as helpful. I will use your advice as soon as I make sure that there is no other way to escape reserved characters somehow, when using load inline.

Thanks for your answer.

Panayotis

How can I load inline a value that contains a QV-script-reserved character?

rwunderlich — Mon, 19 Dec 2011 16:47:29 GMT

Read the Help for Load Inline (in the Load keyword). The answer is there

-Rob

Re: How can I load inline a value that contains a QV-script-reserved character?

Tue, 20 Dec 2011 08:00:21 GMT

Hi Rob,

Thanks for your answer.

Do you imply that I should use double quotes instead of square brackets in order to delimit my data in the load inline statement?

I suppose yes. I got it working after your comment, without having to go to EXCEL solution.

Thanks a lot.

Panayotis

P.S. Have marked your answer as correct one.

How can I load inline a value that contains a QV-script-reserved character?

rwunderlich — Tue, 20 Dec 2011 13:26:56 GMT

Panayotis,

Yes, double quotes was the solution I was thinking of. Glad you got it working.

-Rob