Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
LOAD ...
FROM File.csv
WHERE IsNum(prodID);
use if condition like below while loading
load if(isnum(ID),ID) as ID, field2;
load ID,field2 from abc;
Try as below
Load .....
From FileName
Where IsNUM(prodID);
thank you guys...