Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I'm trying to get two different level metrics into one column and to appear under one. So it would be normally:
level 3 -- level 5
But now I want,
Level 3
Level 5
If that makes sense?
maybe
newTable:
load *
,[level 3] as CombinedField
resident originalTable;
concatenate(newTable)
load *
,[level 5] as CombinedField
resident originalTable;
drop originalTable;
maybe
newTable:
load *
,[level 3] as CombinedField
resident originalTable;
concatenate(newTable)
load *
,[level 5] as CombinedField
resident originalTable;
drop originalTable;