With out Rename

[NavinReddy]

Hi All,

I have a Query will some help me

LOAD * INLINE [

    Place

    Ban

    Hyd

    Del

    Kol

];

display the field names as full form like

Ben-Bangalore

Hyd-Hyderabad

Del-Delhi

Kol-Kolkotta

without using rename option

Thanks & Regards

Niranjan

[sujeetsingh]

Hi,

it seems you are trying correlate the full names.

See this sample.

[NavinReddy]

Hi Sardar,

yes ,it should disply full names im using personal edision will you please copy and paste it here

Thanks & Regards

Niranjan

[sujeetsingh]

Are you not able to get htis sample.

You can use this type code

=if(City='DL','Delhi',

   if(City='PU','Pune',

   if(City='NAG','nagpur')))

[kumarnatarajan]

Hi,

try this to your list box expression

Ex:

=if(Place='Ban','Bangalore',

if(Place='Hyd','Hyderabad',

if(Place='Del','Delhi',

if(Place='Kol','Kolkotta'))))

see below screen short.

[er_mohit · Accepted solution]

Yeah its possible through inline load

see example

PP:

mapping LOAD * INLINE [

    Place,Name

    Bang,Banglore

    Hyd,Hyderabad

    Del,Delhi

    Kol,Kolkatta

];

Map Place using PP;

LOAD * INLINE [

    Place

    Bang

    Hyd

    Del

    Kol

];

[NavinReddy]

Hi All,

Thanks a lot for replay

Thanks & Regards

Niranjan