Merge two dimension into one

[BearNBeer]

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 · Accepted solution]

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
]
;