2 Replies Latest reply on May 10, 2018 5:05 AM by Jim Dehner

    Appending Data

    Prasenjit Datta

      Hello Everyone.

       

      I want to connect Tableau with Box. The Box folder get updated every week with a new file but similar data. How do I add new data to my existing database in tableau. In other words, I want my this week data to last week data.

       

      Thanks,

       

      Prasenjit

        • 1. Re: Appending Data
          anil saini

          Hi Prasenjit,

          I don't have prior experience with Box, but I can suggest:

           

          write a script which will take 1 file and whenever new file comes, it will take its data and merge it into the previous one.

           

          and connect that to tableau with the live connection

           

          so whenever your new file comes up, the script will run, it will take the new data, paste it in old and then tableau will also show you latest data.

          1 of 1 people found this helpful
          • 2. Re: Appending Data
            Jim Dehner

            Good morning

            It depends on the format of the data that you are pulling from Box

            but the usual approach to appending data to an existing Tableau data base is to UNION the data sets

            see the link     Union Your Data       and look at Wildcard Union

             

            also see  Tableau Prep  Tableau Prep      as an additional approach

             

            Jim

            If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.