remove the value not required

[bsbernabe]

Hello There,

This is my sample data my concern is to remove if all the value of Serial No. is =0 or 1 or - or null and how can i do this in load script ?

Agreement ID	Customer Name	Serial No	Trans_Date
135844	ROMEO TORRES	2DY1011234	03/06/2015
137706	BOYET BAY	G123-206366	03/24/2015
220859	JUN FOX	1	07/31/2016
291720	RAM	1	06/30/2017
155886	WAREHOUSE	0	08/08/2015
155864	DEPO	-	10/08/2015

Best Regards,

Bing

[Arthur_Fong · Accepted solution]

Try this:

Raw:
load * inline [
Agreement ID,Customer Name,Serial No,Trans_Date
135844,ROMEO TORRES,2DY1011234,03/06/2015
137706,BOYET BAY,G123-206366,03/24/2015
220859,JUN FOX,1,07/31/2016
291720,RAM,1,06/30/2017
155886,WAREHOUSE,0,08/08/2015
155864,DEPO,-,10/08/2015
];
NoConcatenate
tempRaw:
load * resident Raw
where len([Serial No])>1;
DROP Table Raw;

Rename table tempRaw to Raw;

[Surya]

Hello.,

Directly doing in Front end in dimentsion 

if(len([serial no] > 1) ,[Serial No],Isnull())

Try this in Front end

In Backend

before semi column

where len([serial no] >1);

[bsbernabe]

Thank you for your great support