How to load CSV file with data in this format?

[jblomqvist]

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?

[sunny_talwar · Accepted solution]

You can use a file wizard to do that for you

[avinashelite]

Sunny is right ,

Go to edit script>table files > select the file >Choose the custom delimiter > search the delimiter you want and click OK qlikview generate the required script

[jblomqvist]

Helpful as always Sunny, thank you

[florentina_doga]

try this

LOAD [OrderID ],

     [OrderDate ],

     [CompanyName ],

     Value

FROM

[Book1.csv]

(txt, codepage is 1252, embedded labels, delimiter is '|', msq);