1 Reply Latest reply on May 25, 2018 10:36 AM by Yuriy Fal

    Wildcard Union of Box Files

    Alexander Lam

      Hi There,

       

      When working locally, I can use a wildcard union to automatically combine a number of excel files in a single data connection. Am I able to do this via a Box connection? When I attempt this after selecting Box as my data source, it seems I can only connect a single file and search within the sheets of said file.

       

      Currently using Tableau Desktop 10.5.3

      Any input helps!

      Screen Shot 2018-05-18 at 6.08.18 PM.png

        • 1. Re: Wildcard Union of Box Files
          Yuriy Fal

          Hi Alexander,

           

          I doubt you can use a (Wildcard) Union on multiple Excel files.

          One can do it only with the sheets from the single (Excel) file.

          Text/CSV is a different matter (you know).

           

          As for the cloud file storage (Box, Dropbox, OneDrive, Google Sheets) --

          same experience as with Excel (single file / multiple sheets).

           

          So a workaround would be using Box client application, 

          which could mount a Box storage pointing to your local directory.

          Having CSV files in there, you'd be able to make a Union in Tableau.

           

          Of course, there would be imminent problems

          with sharing this mount point with your colleagues

          and/or updating the datasource from Tableau Server.

           

          Yours,

          Yuri

          1 of 1 people found this helpful