Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accounts_001:
LOAD * INLINE [
SOURCE,Company_ID, Customer_Name, Segment,Segment_Type
TS,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg, sales@supercom.com.sg
TS,CET00838-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
TS,CET00839-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
];
Company_ID=CET00837-SGD
May i know how to solve ? My excepted result as below :-
Paul
LOAD * INLINE [
SOURCE,Company_ID, Customer_Name, Segment,Segment_Type
TS,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg, sales@supercom.com.sg
TS,CET00838-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
TS,CET00839-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
] where Match(Company_ID,'CET00837-SGD')>0;
LOAD * INLINE [
SOURCE,Company_ID, Customer_Name, Segment,Segment_Type
TS,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg, sales@supercom.com.sg
TS,CET00838-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
TS,CET00839-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
] where Match(Company_ID,'CET00837-SGD')=0;
LOAD * INLINE [
SOURCE,Company_ID, Customer_Name, Segment,Segment_Type
TS,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg, sales@supercom.com.sg
TS,CET00838-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
TS,CET00839-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
] where Match(Company_ID,'CET00837-SGD')>0;
Hi sir
I make a mistake.
What i want is
Company_ID not equal to CET00837-SGD'
Hope you an advise me
Paul Yeo
LOAD * INLINE [
SOURCE,Company_ID, Customer_Name, Segment,Segment_Type
TS,CET00837-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg, sales@supercom.com.sg
TS,CET00838-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
TS,CET00839-SGD, SUPER COMPONENTS (S) PTE LTD, sales@supercom.com.sg,
] where Match(Company_ID,'CET00837-SGD')=0;