Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Sir
I have product field.
inside the product field it have data
Hakko
Hakko/Beckhoff
Hakko/Beckhoff/Mitsubishi
May i know how to create
a new field name "Hakko_User" to list those who customer interested in "Hakko"
a new field name "Beckhoff_User" to list those who customer interested in "Beckhoff"
So that i can easily filter out Hakko user.
Paul
Hi
Sorry i missed comma in expression
please try again
LOAD
COL_1,
if (SubStringCount ( COL_1, 'Hakko' ) >0, 'Hakko','No Hakko') as Hakko_User,
if (SubStringCount ( COL_1, 'Beckhoff' ) >0, 'Beckhoff','No Beckhoff') as Beckhoff_User
Resident tablename;
Regards
An Pham
Hi
Using Index or substringcount function
Ex:
if (SubStringCount ( [product field], 'Hakko' ) >0 'Hakko','No Hakko') as Hakko_User
if (SubStringCount ( [product field], 'Beckhoff' ) >0 'Beckhoff','No Beckhoff') as Beckhoff_User
Regard
An Pham
Hi Pham
I get error msg :-
Error in expression:
')' expected
Thank you for your help.
Paul Yeo
Hi
Sorry i missed comma in expression
please try again
LOAD
COL_1,
if (SubStringCount ( COL_1, 'Hakko' ) >0, 'Hakko','No Hakko') as Hakko_User,
if (SubStringCount ( COL_1, 'Beckhoff' ) >0, 'Beckhoff','No Beckhoff') as Beckhoff_User
Resident tablename;
Regards
An Pham
missing comma
if (SubStringCount ( [product field], 'Hakko' ) >0 , 'Hakko','No Hakko') as Hakko_User
if (SubStringCount ( [product field], 'Beckhoff' ) >0 , 'Beckhoff','No Beckhoff') as Beckhoff_User
Thank you PM.
Hi Pham
Can you share with me how you paste those script on your reply ? After you paste the back ground have line number 1 to 5.
Paul
Hi
Using Advanced Editor and format code
Regards
An Pham
sub
wow this is very useful
thank you for sharing with me
end