1 Reply Latest reply on Apr 25, 2013 1:08 PM by Son Stegmaier

    Best way to handle daily .csv files

    Joseph Pope

      I am using Tableau Desktop and want to visualize daily .csv files such that each day's file is a separate tab in the workbook.  I am currently creating a new connection (to each day's Excel file) for each tab, but this doesn't seem like the best or most effective way to do this. 

       

      Are there alternate data import methods I should be using?  Thanks. 

        • 1. Re: Best way to handle daily .csv files
          Son Stegmaier

          Are the .csv files the same layout?  If the file layout is the same, I would recommend building an extract and then adding the data files to the extract.

           

          Create one worksheet and place a filter on your date field from the file. (if the daily .csv doesn't have a date field, I recommend creating a date field with extract the date)