1 Reply Latest reply on Sep 3, 2016 8:14 AM by Mahfooj Khan

    About creating a union from excel Sheet

    Sarwesh Kulkarni

      I am Sarwesh Kulkarni from Smruthi Organics Ltd. me and my teammates have just started to work on tableau 10, we are not able to create a union between two different sheets in excel to carry out analysis in the same worksheet of Tableau, before creating a union all the data was properly shown in 1st worksheet, but an error occurred after creating the union and it stated as follows, "

      (restrict

        (aggregate

          (select

            (project

              (leftjoin

                (table [TableauTemp].[PH$])

                (restrict

                  (table [TableauTemp].[TDS$])

                  ([Areation Feed Tank] [Areation Tank 1] [Areation Tank 2] [Date] [Equilization Tank] [Filter Feed Tank] [MEE condensate] [MEE Feed 120 kl Tank] [RO permeate] [Secondary Clarifire 1] [Secondary Clarifire 2] [TWT])

                  )

                (

                  ([Areation Feed Tank] [Areation Feed Tank])

                  ([Areation Tank 1] [Areation Tank 1])

                  ([Areation Tank 2] [Areation Tank 2])

                  ([DATE] [Date])

                  ([Equilization Tank] [Equilization Tank])

                  ([Filter Feed Tank] [Filter Feed Tank])

                  ([MEE condensate] [MEE condensate])

                  ([MEE Feed 120 kl Tank] [MEE Feed 120 kl Tank])

                  ([RO] [RO permeate])

                  ([Secondary Clarifire 1] [Secondary Clarifire 1])

                  ([Secondary Clarifire 2] [Secondary Clarifire 2])

                  ([TWT] [TWT])

                  )

                ()

                )

              (

                ([mn:DATE:ok]

                  (month [DATE])

                  )

                )

              )

            (not

              (isnull [mn:DATE:ok])

              )

            )

          (

            ([mn:DATE:ok] [mn:DATE:ok])

            )

          (

            ([avg:Areation Feed Tank:ok]

              (average [Areation Feed Tank])

              )

            ([avg:Areation Tank 1:ok]

              (average [Areation Tank 1])

              )

            ([avg:Areation Tank 2:ok]

              (average [Areation Tank 2])

              )

            ([avg:Equilization Tank:ok]

              (average [Equilization Tank])

              )

            ([avg:Filter Feed Tank:ok]

              (average [Filter Feed Tank])

              )

            ([avg:Secondary Clarifire 1:ok]

              (average [Secondary Clarifire 1])

              )

            ([avg:Secondary Clarifire 2:ok]

              (average [Secondary Clarifire 2])

              )

            ([avg:TWT:ok]

              (average [TWT])

              )

            )

          )

        ([avg:Areation Feed Tank:ok] [avg:Areation Tank 1:ok] [avg:Areation Tank 2:ok] [avg:Equilization Tank:ok] [avg:Filter Feed Tank:ok] [avg:Secondary Clarifire 1:ok] [avg:Secondary Clarifire 2:ok] [avg:TWT:ok] [mn:DATE:ok])

        )

      Me and my teammates are not used to handle this stuff so please help us out. You can contact me over my cell phone as well, Mob. No.: +91 9168305898

       

      Best Regards,

       

      Sarwesh Kulkarni

       

      Smruthi Organics Ltd