Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP & Luminary
MVP & Luminary

QV11 Editor Problem

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.

4 Replies

QV11 Editor Problem

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

MVP & Luminary
MVP & Luminary

QV11 Editor Problem

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

QV11 Editor Problem

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)

MVP & Luminary
MVP & Luminary

QV11 Editor Problem

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.