I have following table structure where in the I have many to one and one to many joins.
o when I pull objects from all the tables it gave me multiple rows so I created context1 and context 2.
But now when I pull these objects it creates 2 different tables and I cant put all the objects together which I need in the report.
To overcome this I need to do the Merge dimension but when I select all these three Lead IDs its greyed out,is it because of the data type?
Please suggest the best way to pull these objects?