2 Replies Latest reply on Apr 18, 2018 12:26 PM by Eric Liong

    Union by position

    Eric Liong

      Hi all,


      Is union by position not currently a feature in Maestro 0.4?


      Currently I can re-name all my fields to match however this is time consuming and doesn't work with more files/fields.

      Currently I have 4 data collectors from my Tableau Server returning server status. (Ram memory usage etc).


      These files are in separate locations which currently can't be unioned in Tableau but can be unioned in Maestro. In Maestro I'm able to get one server view showing all server node status.


      I tried searching around but haven't found anything yet.



        • 1. Re: Union by position
          Joshua Milligan



          This would be an incredibly useful feature and I would very much endorse it!


          In the meantime, if you are using files as the data source, then you might consider checking the "Generate field names automatically" on the Text Settings tab of the Input step:



          Then, Maestro will assign automatic names to each field (F1, F2, F3, etc...).  That will give you a consistent positional name for each field for the union.  The tedious step will be renaming after the union, but at least it's just once per field and not once per field per file!


          Hope that helps!


          1 of 1 people found this helpful
          • 2. Re: Union by position
            Eric Liong

            Thanks Joshua!


            I reviewed the behavior in Tableau Desktop and got virtually the same results. So it looks like a union by position just by a different name.


            I think it's one of those options where there's a disconnect between the title and function (At least in my brain)

            Kind of like explaining the hundredth time that "Show sheets as tabs" up ends our workbook inherited permissions.


            Supposedly 2018.1 adds some more explanation, guess I'll have to hop onto the beta to find out!