1 Reply Latest reply on Oct 20, 2016 11:00 PM by Mahfooj Khan

    Ignore first row of csv file on import

    michelle.pace

      Hi there,

       

      I have a CSV file where the Field Names only start in Row 2. As such I need to be able to ignore the first Row when opening this Text File. Is there a way to do this in Tableau 10?

       

      2608252485,"Industrial Park",2014,2016

      rdate,rtime,kWh+,kvarh+,kWh-,kvarh-,kVA,pf,Status,Register

      2014-09-01,00:30:00,6.360,10.560,0.000,0.000,24.655,0.52,Good,25616.88

      2014-09-01,01:00:00,5.640,10.200,0.000,0.000,23.311,0.48,Good,25622.52

      2014-09-01,01:30:00,6.240,9.960,0.000,0.000,23.507,0.53,Good,25628.76

       

      Thanks,

      Michelle