topic Re: Issue with inline table in QlikView

Issue with inline table

Tue, 12 Jan 2016 11:09:49 GMT

I am trying to create an inline table to hold some dimensions. When running the script I have getting an error which says that there is a missing FROM statement, but the table is being created inline without the need for any external data.

If anyone else has had this issue before please let me know if/how you were able to solve it.

Many thanks,

Re: Issue with inline table

PrashantSangle — Tue, 12 Jan 2016 12:18:17 GMT

Hi,

Share your script ..

basic syntax is

Load * INLINE [

FieldName

value1,

value2

]

Regards

Re: Issue with inline table

Anonymous — Tue, 12 Jan 2016 12:21:28 GMT

Paste your script here, that would help us to identify the issue....

Re: Issue with inline table

sunny_talwar — Tue, 12 Jan 2016 12:22:42 GMT

I guess it would be difficult to say what might be causing the error without looking at your code for the inline table. Can you share the script for the Inline table?

Re: Issue with inline table

tresB — Tue, 12 Jan 2016 12:27:10 GMT

One common tempting error: No space between 'Inline' and '['. Check that.

So try like:

Load * inline [ .. // space after 'inline'

Re: Issue with inline table

Tue, 12 Jan 2016 12:28:54 GMT

Tresesco,

This was it!! I feel stupid for not seeing that, but I assumed that the syntax highlighter would point it out. Not much point in having a button for a syntax checker if it doesn't work!!!

Thanks,