3 Replies Latest reply on Sep 12, 2019 5:35 AM by kumar Su

    CSV import in Tableau Desktop

    kumar Su

      Greetings,

        

      I started to use Tableau Desktop as a tool to visualize the data. I would receive the daily one flat file.

      However, the data is stored in CSV files with a date format name (e.g. datasample_yyyymmdd.csv). I need to be able to daily load in files as the date is changing every day.

      Each day file will have the same format  and I want to create the trending report (daily,weekly,monthly,yearly)  from source files ..

      Here is the sample data file !!

      MachineIDDivisionMachineStatusLoadDate
      10SalesFail9/8/2019
      10SalesPass9/8/2019
      10SalesPass9/9/2019
      10MechanicalPass9/8/2019
      11MechanicalPass9/9/2019
      11MechanicalPass9/9/2019
      11MechanicalPass9/9/2019
      11MechanicalFail9/9/2019
      Except Output
      RunDate9/8/20199/9/2019
      DivisionMachine- Availability

      Machine-availability

      Sales50%100%
      Mechanical100%75%

       

      Thanks a lot for your help in advance !!