Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Mar 22, 2017, 9:31 AM

Compare a cell with other column values

Hi guys,

 

I am new to Tableau and currently stuck with the following problem.

 

I have the following sample table:

Compare a cell with other column values

 

I want to compare E.No with S.No and display S_Name value into E_Name based on this comparison.

 

For example, E.No is 2 which results E_Name to be "B" in the first row. Please find the below expected result:

pastedImage_7.png

 

I wanted to do this without using Joins because the data source I am using is really huge which creates performance issues. Is there a way I can implement this using some kind of Calculated field or any other simpler method.

 

Thanks in advance for your help and support.

5 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Mar 22, 2017, 10:15 AM

    Hi Pradeep,

     

    One of the possible way to achieve your desired result is using tableau data blending. Lets assume your primary data source is your sample table and secondary data source is duplicate of your primary data source. Then you can blend both the datasources on E.No (Primary DS) and S.No(Secondary DS). then put dimensions and measures as per attached workbook.

    Hi Pradeep, One of the possible way to achieve your desired result is using tableau data blending.

    pastedImage_3.png

     

    Check attached workbook for your reference.

     

    Thanks,

    Nikunj

Write an answer...
0/9000