topic Split csv file to mulitple tables in QlikView https://community.qlik.com/t5/QlikView/Split-csv-file-to-mulitple-tables/m-p/256031#M710445 <HTML><HEAD></HEAD><BODY><P>I have a csv/excel file wich contains multiple datasets</P><P>Is is possible to load that into different qlikview tables( budet,income and employees). ? </P><P></P><P>The csv file looks like this: </P><P></P><P>budget</P><P>cake company;2011;12000</P><P>cake company;2010;15000</P><P>cake company;2009;18000</P><P>income</P><P>2011;cake company;1200</P><P>2010;cake company;15500</P><P>2009;cake company;5000</P><P>2008;cake company;4000</P><P>2007;cake company;3000</P><P>employees</P><P>2011; Tom</P><P>2011; Jill</P><P></P><P></P><P>My initial tough was to load everything into a tmp table, loop and add the header to each line as a extra column.</P><P>then i could resident load into multiple tables where "table_type" = "income" etc. </P><P></P><P>Any ideas on how to accomplish this? </P></BODY></HTML> Wed, 01 Jun 2011 07:59:46 GMT 2011-06-01T07:59:46Z Split csv file to mulitple tables https://community.qlik.com/t5/QlikView/Split-csv-file-to-mulitple-tables/m-p/256031#M710445 <HTML><HEAD></HEAD><BODY><P>I have a csv/excel file wich contains multiple datasets</P><P>Is is possible to load that into different qlikview tables( budet,income and employees). ? </P><P></P><P>The csv file looks like this: </P><P></P><P>budget</P><P>cake company;2011;12000</P><P>cake company;2010;15000</P><P>cake company;2009;18000</P><P>income</P><P>2011;cake company;1200</P><P>2010;cake company;15500</P><P>2009;cake company;5000</P><P>2008;cake company;4000</P><P>2007;cake company;3000</P><P>employees</P><P>2011; Tom</P><P>2011; Jill</P><P></P><P></P><P>My initial tough was to load everything into a tmp table, loop and add the header to each line as a extra column.</P><P>then i could resident load into multiple tables where "table_type" = "income" etc. </P><P></P><P>Any ideas on how to accomplish this? </P></BODY></HTML> Wed, 01 Jun 2011 07:59:46 GMT https://community.qlik.com/t5/QlikView/Split-csv-file-to-mulitple-tables/m-p/256031#M710445 2011-06-01T07:59:46Z