Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

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
sunny_talwar

You can use a file wizard to do that for you

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

You can use a file wizard to do that for you

Capture.PNG

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
Specialist
Specialist
Author

Helpful as always Sunny, thank you

florentina_doga
Partner - Creator III
Partner - Creator III

try this

LOAD [OrderID ],

     [OrderDate ],

     [CompanyName ],

     Value

FROM

[Book1.csv]

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