3 Replies Latest reply on Sep 18, 2016 6:29 PM by siyang.teo

    Any way to show joined column

    siyang.teo

      Is there a way to show the column which is used in the table join inside Tableau?

       

      Can't seem to find a way to do it...

        • 1. Re: Any way to show joined column
          Shriram Saxena

          Hi Siyang,

           

          Yes we can

           

          here the join is made on order id ..

           

          Now go to sheet.. 

           

           

          Now you can see the columns where join can be made...

          Is this what you are looking for ... 

           

           

          Best

          Shriram Saxena 

          1 of 1 people found this helpful
          • 2. Re: Any way to show joined column
            Rajeev Pandey

            Hi Teo,

            No need to worry , please follow the below steps and you will get the desired result.

            1) First create a Join( Either by drag down or by using Custom SQL technique)

            2) When A join is happening , you will see a table name is getting prefixed with the Join as per the below image.

            3) Go to the sheet View and access the Field.

            4) Optional:

            I am just making a Wild Guess, may be you have checked the "Group By folder Option"  which is making it difficult to find.

            You can just change the value to "Group By Data source Table"

            5) Or follow the simplest technique of searching by field name.

            if still nothing works out then Define the column name by using Custom Sql query technique.

            Let me know if you still face any issue.

             

            Warm regards,

            Rajeev pandeyFollow my Blog:

            TableauLearners - TableauLearners

            1 of 1 people found this helpful
            • 3. Re: Any way to show joined column
              siyang.teo

              This is embarrassing, after viewing both of your posts, and realised that they should rightly be available, it dawned on me that I have hid the fields.

               

              No wonder I couldn't locate them even after searching them as you suggested.

               

              While the answers you provided are not exactly what resolved it, but they certainly led to the resolution. Appreciate them much!