Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table with Cost_Area field which has values as:
I'm trying to create a separate column "Area" as shown in the image below;
where Controls Eng = 'CONT HDWR', 'CONT RESALE', 'CONTROLS ENG' values
Mechanical Eng = 'MECH HDWR', 'MECH INSTALL', 'MECH RESALE' values
I came to know that using Appymap we can create a mapping table of required fields and create a separate column, if this approach is the right way How can I do this?
attach is the file for reference
thanks