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: 
Not applicable

QV11 Editor Problem (inline load)

While using an inline load in QV11, i stumbeled upon a problem.

// comments in the inline load

were not ignored, but loaded inline.

This resulted in this strange collumn:

21-02-2012 QV editor fail.png

// comments work fine outside inline loads.

It seems this is a bug, or is there a way to prevent this ?

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try the following script

Temp:

Load

*

FROM DataSource;

Data:

LOAD

*

RESIDENT Temp

WHERE Left(LTrim(MS), 2) <> '//';

This would remove the rows with '//'.

Hope this helps you.

Regards,

Jagan.

View solution in original post

4 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     I think its not a bug its inline functionality.

     It process everything Inside the [ ].

     It takes first rows as field names and after that as field values.

Celambarasan

jagan
Luminary Alumni
Luminary Alumni

Hi,

It is not a bug.  Qlikview treats // as a value in in Inline[];  It is not possible to comment in Inline.  Instead you just remove that line directly or else filter this using where condition.

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

great, so its "not" a bug, its a feature...

at least there is the option to filter out the comments (which should be QVs job)

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try the following script

Temp:

Load

*

FROM DataSource;

Data:

LOAD

*

RESIDENT Temp

WHERE Left(LTrim(MS), 2) <> '//';

This would remove the rows with '//'.

Hope this helps you.

Regards,

Jagan.