Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Case 934 How to load only Company_ID=CET00837-SGD ?

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 :-

paulyeo11_0-1600430872250.png

 

Paul

2 Solutions

Accepted Solutions
Taoufiq_Zarra

@paulyeo11 

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;

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Taoufiq_Zarra

@paulyeo11 

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;

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

3 Replies
Taoufiq_Zarra

@paulyeo11 

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;

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
paulyeo11
Master
Master
Author

Hi sir

I make a mistake.

What i want is 

Company_ID not equal to CET00837-SGD'

Hope you an advise me

Paul Yeo

Taoufiq_Zarra

@paulyeo11 

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;

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉