ignore rows with certain data?

[#1]

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.

[Nicole-Smith · Accepted solution]

LOAD ...

FROM File.csv

WHERE IsNum(prodID);

[#3]

use if condition like below while loading

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

load ID,field2 from abc;

[MK_QSL]

Try as below

Load .....

From FileName

Where IsNUM(prodID);

[#5]

thank you guys...