3 Replies Latest reply on Sep 9, 2018 10:32 PM by Rajesh Jaiswal

    How to Create New Column by Combining Unique Values from columns of two different data sources

    Rajesh Jaiswal

      Hi All,

      I am new to Tableau, I would like to have insight from all of you.

      Senario:  I have two datasources like below:

       

      Data Source 1: 

            Region,      Server Type      Count

            Reg1             S1                   200

            Reg2             S2                   300

            Reg3             S3                   500

       

      Data Source 2: 

            Region,      Server Type      Count

            Reg1             S4                   200

            Reg2             S5                   300

       

      Now I want new Column which having all unique values of (Combined Server Type) such as (S1,S2,S3,S4,S5)

       

      so I want final data should be like

       

                                                        Combined Server Type

                        |       S1        |       S2          |     S3        |       S4        |       S5

      Region       |                   |                      |

      Reg1          |     200        |                      |                       200 

      Reg2          |                   |      300         |                                              300

      Reg3         |                    |                      |    500    

       

       

      Also, How should i convert ATTR to Dimension.

       

      Thank you