Need to join output of an explore which is pivoted (number of columns may change as per the filters) with another explore

[kshah1]

I have created an explore and based on the filters it provides output in the following format:

Dim1	Dim2(String)	StringValue
1	key1	val1
1	key2	val2
1	key3	val3

And we pivot this to the following format.

dim1	key1	key2	key3
1	val1	val2	val3

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.