Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jblomqvist
Contributor II

How to load CSV file with data in this format?

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?

1 Solution

Accepted Solutions

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

You can use a file wizard to do that for you

Capture.PNG

4 Replies

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

You can use a file wizard to do that for you

Capture.PNG

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

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
Contributor II

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

Helpful as always Sunny, thank you

florentina_doga
Contributor III

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

try this

LOAD [OrderID ],

     [OrderDate ],

     [CompanyName ],

     Value

FROM

[Book1.csv]

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

Community Browser