apply map ,if

[Siddhanttomar]

can any one help me with 5th part using these tables 

5.Use If() Condition to generate Full City Name from PFCity Column

[Vegar · Accepted solution]

• Create a mapping table using Table C.
• Fetch  your City ID from Table A by using the SubField() function. (Fetch the second value using / as the delimiter. 
• Use the CityID as your lookup value on your Table C mapping table.

[Siddhanttomar]

can you please explain in little bit in detail with some scripts

[Siddhanttomar]

thrid step in detail would more help full

[Taoufiq_Zarra · Accepted solution]

@Siddhanttomar 

for example you can use this script example :

TableC:
mapping load * inline [
City,City Name
MUM,Mumbai
TH,Thane
PU,Pune
];

TableA:

load Employee,Applymap('TableC',subfield(PFNO,'\',2)) as CityName,PFNO inline [
Employee,PFNO
87,IND\MUM\1234
89,IND\PU\1236
];

output:

[Siddhanttomar]

thank you its work