1 Reply Latest reply on Nov 1, 2016 8:36 PM by Sherzodbek Ibragimov

    Calculated field with other data source which connected with each other

    jayhwan cheong

      Okay. The thing is I don't want to do outside tableau. I understand it would be easy just change excel file but I want to know is there any way I could do inside tableau.



      There are two data sources. Each other connected by Shop column(But! the thing is shop column is also made by calculated field)


      So I connected both shop column with data blending. Now, they are connected.


      Here is the question!

      I want to make a calculated field using both data sources. One from a Fruit name the other from a Locate name.

      I tried to make this way but not working

      In a calculated field,

      Fruit_Loc = [Fruit]+ATTR([Sheet1 (Location)].[Location])

      not working.


      Is there any way I could merge fruit name and location name which is connected by shop name.


      I expected like a new column something look like,