Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
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
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.
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)
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.