How to Change values name in the Field

[kalyandg]

Hi all,

I have one requirement,

Field name -- ShowRoom it has values such as
                    India,

                    China,

                    Japan,

                    Australia.....etc

I need not show the values as is original..

instead of India it should show as SRoom1,

               China as SRoom2....etc

how to change the value name in a field?

please help me to solve!

Also in one field Product it has some values with null values...i have to show null value as Others instead of - in chart. Please help me for this issue also?

[er_mohit]

try this in load script

if(ShowRoom=pick(match(ShowRoom,'India','China'),'Sroom1','Sroom2'),ShowRoom)as NewShowroom

[nilesh_gangurde]

Hii Kalyan,

You can use the below mentioned script at load time.

if(wildmatch(ShowRoom,'India'),'Sroom1',

     if(wildmatch(ShowRoom,'China'),'Sroom2',

          if(wildmatch(ShowRoom,'',' ') or isnull(ShowRoom),'NULL')))

Hope this will help you.

-Nilesh

[kalyandg]

hi mohit,

thanks for your reply...
but i have 26 showrooms...
so for all showrooms, whether i have to write in the script?

please reply

Thanks,

Kalyan

[kalyandg]

Hi nilesh ganrude,

Thanks for ur reply

[nilesh_gangurde]

Hiii Kalyan,

Request you to please mark the post as Correct ans or Helpfull Ans.

-Nilesh

[er_mohit · Accepted solution]

For this you hv to use mapping function

like

CountryNamesMap:

Mapping

LOAD * INLINE [

    ShowRoom, Name

    India, Sroom1

    China, Sroom2

     Pak, Sroom3

     US,Sroom4

];

Map NewName using CountryNamesMap;

LOAD * INLINE [

    NewName

    India

    China

    Pak

    US

];

for other country u do it like this

[kalyandg]

HI MOHIT,

THANKS... THIS INLINE LOAD WORKS