Hoping for some help with adding a column to an already loaded table. I have to load the table initially to obtain the values for a subroutine to run. When the subroutine returns it gives me an additional field to add back to the dataset.
Sub mySub (searchColumn, OriginalTable)
\\some processes here that succesfully obtain back a new column of data
mapping load searchColumn,
//This part is the area where I'm struggling. I'm trying to get the newColumn from ResultTable onto OriginalTable as an additional field.
Load *, applymap('MappingTable', 'searchColumn', 'Not available') As newColumn resident OriginalTable;
I was able to get the end result by simply making a new table which is a combination of OriginalTable and ResultTable (via join) but I'm hoping there is a more efficient method than making an entirely new table and dropping the original.