topic Concatenate 2 dimensions into one column in App Development

Concatenate 2 dimensions into one column

jdam0074 — Thu, 02 Sep 2021 18:08:22 GMT

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 — Thu, 02 Sep 2021 19:33:32 GMT

maybe

newTable:

load *

,[level 3] as CombinedField

resident originalTable;

concatenate(newTable)

load *

,[level 5] as CombinedField

resident originalTable;

drop originalTable;