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 am trying to combine multiple fields ('CONT HDWR', 'CONT RESALE', 'CONTROLS ENG') in load script as one field (named "Controls Eng"). So, my resultant column "Controls Eng" would be a list having values like 'CONT HDWR', 'CONT RESALE', 'CONTROLS ENG' and not the other fields.
How can I do this?
attach is the file for reference