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:
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?