start with

[raadwiptec]

hi all,

how can I write on script for start with

for ex

if column country start or contains can then 'CA'

[robert_mika]

Try:

if(WildMatch(Country,'*can*'),'CA') as CA,

[jsingh71]

Try:

Load

--------------------

If(Left(Country,3) = 'can', 'CA', Country) as Country,

---------------------

---------------------

[Kushal_Chawda]

create a field in script with below condition

if(wildmatch(lower(Country),'*can*','CA',Country) as Country