Concatenate 2 dimensions into one column

[jdam0074]

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?

[stevejoyce · Accepted solution]

maybe

newTable:

load *

,[level 3] as CombinedField

resident originalTable;

concatenate(newTable)

load *

,[level 5] as CombinedField

resident originalTable;

drop originalTable;