Hi,
Wondering if anyone can assist? I am writing several workflows where I am bringing in baseline data and 'Market' data. When I join / union these data streams, they all have the column names.
What I would like to do is dynamically rename all the columns to identify which are coming from the baseline and which are from the market, so an example:
EXPENSE ACCOUNT PRIORITY CONTROL
As these would be the same in both I would like to rename as:
MKT EXPENSE, MKT ACCOUNT, MKT PRIORITY etc for the markets and:
GSIP EXPENSE, GSIP ACCOUNT, GSIP PRIORITY for the baseline
Not sure how I can do this? For each query the headings change which is why I would like a solution that just prefixes the column with either MKT or GSIP.
