Discussion Board for collaboration on QlikView Scripting.
I have a CSV file with data in this format:
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?
Go to Solution.
You can use a file wizard to do that for you
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
Helpful as always Sunny, thank you
LOAD [OrderID ],
(txt, codepage is 1252, embedded labels, delimiter is '|', msq);