topic Re: How to load CSV file with data in this format? in QlikView

How to load CSV file with data in this format?

jblomqvist — Thu, 14 Apr 2016 11:38:25 GMT

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?

Re: How to load CSV file with data in this format?

sunny_talwar — Thu, 14 Apr 2016 11:40:40 GMT

You can use a file wizard to do that for you

Re: How to load CSV file with data in this format?

avinashelite — Thu, 14 Apr 2016 11:47:48 GMT

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

Re: How to load CSV file with data in this format?

jblomqvist — Thu, 14 Apr 2016 11:52:38 GMT

Helpful as always Sunny, thank you

Re: How to load CSV file with data in this format?

florentina_doga — Thu, 14 Apr 2016 12:00:40 GMT

try this

LOAD [OrderID ],

[OrderDate ],

[CompanyName ],

Value

FROM

[Book1.csv]

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