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:
// comments work fine outside inline loads.
It seems this is a bug, or is there a way to prevent this ?
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.
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.
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)
Try the following script
WHERE Left(LTrim(MS), 2) <> '//';
This would remove the rows with '//'.
Retrieving data ...