Code

[deepakqlikview_123]

Hi all,

Can you please suggest what would be optimized code for code given below.

if(FuelType='Diesel' or FuelType='DIESEL','Diesel',If(FuelType='LPG','LPG',If(FuelType='CNG','CNG')))as FuelType

If fuel type is Diesel or DIESEL then i need to display DIESEL or if fuel type is CNG then CNG and if LPG then LPG.

Thanks,

Deepak

[its_anandrjs]

You can try with

if(Match(FuelType='Diesel','DIESEL'),'DIESEL',

If(Match(FuelType='LPG'),'LPG',

If(Match(FuelType='CNG'),'CNG'))) as FuelType

[preminqlik]

Load *,

upper(trim(FuelType) )              as          NewFuelType

from path;

[its_anandrjs]

Another way is

Load

Trim(if(Match(FuelType='Diesel','DIESEL'),'DIESEL',

       If(Match(FuelType='LPG'),'LPG',

       If(Match(FuelType='CNG'),'CNG'))) ) as FuelType

From Location;

[deepakqlikview_123]

Hi Anand,

It is giving me syntax error.

[NareshGuntur]

Hi Deepak,

Try this

if(Upper(FuelType)='DIESEL','DIESEL',if(Upper(FuelType)='LPG','LPG',if(Upper(FuelType)='CNG','CNG')))

[anbu1984]

=if(Match(FuelType,'Diesel' ,'DIESEL','LPG','CNG'),Upper(FuelType))