topic Re: Merge two dimension into one in App Development

Merge two dimension into one

BearNBeer — Thu, 29 Jul 2021 09:41:02 GMT

Hello,

I have two dimensions which I am going to call "Dim A" and "Dim B", like this :

Is there a way to merge them so they appear like that :

Thanks

Vegar — Thu, 29 Jul 2021 12:25:51 GMT

You can do it in the script by loading the data like this.

LOAD ID, SubField([Dim A]&'|'&[Dim B], '|') as [Dim AB] inline [
ID, Dim A, Dim B
1, Dim A1, Dim B4
2, Dim A2, Dim B5
3, Dim A3, Dim B6
]
;