Case 938 How to Flag Amount = 0 ?

[paulyeo11]

Hi All

I have below load script :-

Input:

LOAD * INLINE [
Amount,Customer/Vendor, Customer Name, Email, E-Mail
0,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg, sales@supercom.com.sg
0,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
3,CET01610-USD, GRAND VENTURE TECHNOLOGY LIMITED, contact@gvt.com.sg,
4,CET01610-USD, GRAND VENTURE TECHNOLOGY LIMITED, contact@gvt.com.sg, kimhong.chong@gvt.com.sg
5,CET01999-USD,CONVERGENT SYSTEMS (S) PTE LTD
];

load Amount,[Customer/Vendor],[Customer Name],if(len(Amount)=0,'Y','') as Flag resident [Input];

Above line of code for Flag those amount = 0 , Can some one advise me.

Paul

[Taoufiq_Zarra · Accepted solution]

@paulyeo11  if I understood correctly ?

Input:

LOAD *,if(Amount=0,'Y','N') as Flag INLINE [
Amount,Customer/Vendor, Customer Name, Email, E-Mail
0,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg, sales@supercom.com.sg
0,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
3,CET01610-USD, GRAND VENTURE TECHNOLOGY LIMITED, contact@gvt.com.sg,
4,CET01610-USD, GRAND VENTURE TECHNOLOGY LIMITED, contact@gvt.com.sg, kimhong.chong@gvt.com.sg
5,CET01999-USD,CONVERGENT SYSTEMS (S) PTE LTD
];