Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Split csv file to mulitple tables

I have a csv/excel file wich contains multiple datasets

Is is possible to load that into different qlikview tables( budet,income and employees). ?

The csv file looks like this:

budget

cake company;2011;12000

cake company;2010;15000

cake company;2009;18000

income

2011;cake company;1200

2010;cake company;15500

2009;cake company;5000

2008;cake company;4000

2007;cake company;3000

employees

2011; Tom

2011; Jill

My initial tough was to load everything into a tmp table, loop and add the header to each line as a extra column.

then i could resident load into multiple tables where "table_type" = "income" etc.

Any ideas on how to accomplish this?