Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
how can I write on script for start with
for ex
if column country start or contains can then 'CA'
Try:
if(WildMatch(Country,'*can*'),'CA') as CA,
Try:
Load
--------------------
If(Left(Country,3) = 'can', 'CA', Country) as Country,
---------------------
---------------------
create a field in script with below condition
if(wildmatch(lower(Country),'*can*','CA',Country) as Country