I have created an explore and based on the filters it provides output in the following format:
And we pivot this to the following format.
Now, the number of keys can change based on the filters.
I want to join this to another explore which also has dim1 as one of the dimensions, how do I achieve that?
Tried merging but apparently such functionality is being worked upon for over a year now.