Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to skip particular lines when loading data? Eg. I have an excel file that is generated on a daily basis. However one of the fields has both numeric data and not. I am interested in Qlikview to load only the numeric ones. So programmatically I would check if the field is numeric, if false I would skip to next line. But I don't know how to do this in Qlikview. Any help would be much appreciated.
regards,
Roberto
Just add a simple WHERE clause to your load statement. For example:
Data:
LOAD
*
FROM
[Yourfile.xlsx]
(ooxml, embedded labels, table is Houses...)
WHERE IsNum(YourField);
This will only load rows where the value of field YourField is numeric.
Hope this helps,
Jason
Just add a simple WHERE clause to your load statement. For example:
Data:
LOAD
*
FROM
[Yourfile.xlsx]
(ooxml, embedded labels, table is Houses...)
WHERE IsNum(YourField);
This will only load rows where the value of field YourField is numeric.
Hope this helps,
Jason
Thank you very much.