Could you please clarify your original two individual data source and expected result after join?
Thanks for responding...
I have 2 data source C1 and L1 belong to DS1 and C2 and L2 belong to DS2 I already have left outer join between with join condition C1=C2 and L1=L2
above is the result i get on report but i want only below as output on my report
C1 C2 L1 L2 Result 88 88 22 22 TRUE null null null null
Could you please clarify your original two individual data source
I don't know the structure of your data sources, however I've tried to fix your join condition to get the expected output.
First of all using measures as join condition seems quite strange for me. You should use fields which have unique ID.
I've assumed your data sources are like this
I've added Row ID in both the sources to identify each records. Then connect the sources
while applying joining condition instead of left outer join you have to use inner join and most important write calculated joining condition and use IFNULL() to handle the null values as zero so that null values also meet the condition and appears in your result set. Below is the screenshot of the joining condition and output.
workbook attached for your reference. Let us know if this help.
Join_v10.2.twbx 12.3 KB
Could you please share some mock up data in packaged workbook?