Skip to main content
Topics#Tableau Desktop & Web AuthoringShweta Divekar's Question
Shweta Divekar asked in #Tableau Desktop & Web Authoring
Aug 15, 2018, 10:48 PM

Calculated field

Hi Folks,

 

Is it possible to create calculated field with the following condition :

 

I have existing join condition where C1=C2 and L1=L2 at query level but because am using left outer join. i come across data where c1<> c2 or L1<>L2 how can i avoid those data.

 

C1C2L1 L2Result77null26null FALSE88882222TRUEnullnullnullnull TRUEnull77null26FALSE

 

Thanks

7 answers
  1. Shweta Divekar
    Aug 17, 2018, 12:25 AM

    Hi,

     

    I want to filter out data with false value but at same time I want C1(null)=c2(null) and L1(null)=L2(Null) ad valid and true.

     

    Hi, I want to filter out data with false value but at same time I want C1(null)=c2(null) and L1(null)=L2(Null) ad valid and true.

Write an answer...
0/9000