There is a table having a country column. I need to filter out all the names like USA,US,U.S.A,and make them all US.How can we achieve it?

[#1]

Hi,

There  is a table having a country column. I need to filter out all the names like USA,US,U.S.A,and make them all US.How can we achieve it?

Kindly provide the relevant solution.

Thanks,

Neel

[jagan]

Hi,

Try like this

LOAD

*,

If(Match(Country, 'USA','US','U.S.A', 'US', Country) AS NewCountry

FROM DataSource;

Regards,

Jagan.

[MayilVahanan]

HI

Try with Mapping and apply map concept like this

MappingTemp:

Mapping Load  * inline[

Countryname, Country

U.S.A, US

USA, US

US, US

];

Load ApplyMap('MappingTemp', CountryName) as Country, * from tablename;