4 Replies Latest reply: Apr 14, 2016 8:00 AM by florentina dogaru RSS

    How to load CSV file with data in this format?

    John Blomqvist

      Hi all,

       

      I have a CSV file with data in this format:

       

      OrderID | OrderDate | CompanyName | Value
      1001 | 23/01/2016 | Quick Fit Ltd | 56.77
      1241 | 11/03/2015 | Plasters LLP | 334.98
      17780 | 03/02/2016 | Covacs Ltd | 55.66
      096782 | 27/01/2015 | Tot Spots | 87.88

       

      You can see the column names are tab space using |

       

      Does anyone know how I can load this into QlikView and for it to pick up the tab seperated format?