Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables concatenated and there doesnt exist a column name in one of the table. How it can be achieved via ApplyMap() ?
DIMENSION TABLE:
USER ID,
ORG SUB_CATEGORY;
CONCATENATE
USER ID,
ORG NAME,
ORG SUB_CATEGORY;
In the above example i need ORG NAME to be used in ApplyMap() so that ORG SUB_CATEGORY can also be used for further manipulations.
like this
maptable:
mapping load
USER ID,
ORG SUB_CATEGORY;
second table:
USER ID,
applymap('maptable',ORG NAME) as orgname,
ORG SUB_CATEGORY;