Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
try this in load script
if(ShowRoom=pick(match(ShowRoom,'India','China'),'Sroom1','Sroom2'),ShowRoom)as NewShowroom
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
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
Hi nilesh ganrude,
Thanks for ur reply
Hiii Kalyan,
Request you to please mark the post as Correct ans or Helpfull Ans.
-Nilesh
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
HI MOHIT,
THANKS... THIS INLINE LOAD WORKS