Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
]
;
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
]
;