Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ignore rows with certain data?

Hi Experts,

I have a csv file with two columns prodID, productname. Product ID is expected to be a number. But I have characters in few of the records coming from a source system.

How do I load only records with numbers in prodID?

Please help out.

Thank you.

1 Solution

Accepted Solutions
Nicole-Smith

LOAD ...

FROM File.csv

WHERE IsNum(prodID);

View solution in original post

4 Replies
Nicole-Smith

LOAD ...

FROM File.csv

WHERE IsNum(prodID);

Not applicable
Author

use if condition like below while loading

load if(isnum(ID),ID) as ID, field2;

load ID,field2 from abc;

MK_QSL
MVP
MVP

Try as below

Load .....

From FileName

Where IsNUM(prodID);

Not applicable
Author

thank you guys...