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

Skipping Lines when loading data

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

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

View solution in original post

2 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

Not applicable
Author

Thank you very much.