topic Export Table to csv with a complex structure in QlikView https://community.qlik.com/t5/QlikView/Export-Table-to-csv-with-a-complex-structure/m-p/560316#M209150 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps"></SPAN><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"></SPAN><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">Good afternoon</SPAN> <SPAN class="hps">dear friends</SPAN>.<BR /><BR /><SPAN class="hps">Problem</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">the following</SPAN> <SPAN class="hps">kind.</SPAN> <SPAN class="hps">I need</SPAN> <SPAN class="hps">to unload</SPAN> <SPAN class="hps">the data</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">in the CSV</SPAN> <SPAN class="hps">(separator ' ; ') </SPAN><SPAN class="hps">But there is one</SPAN> <SPAN class="hps">Problem</SPAN>, I have <SPAN class="hps">the following structure</SPAN> <SPAN class="hps">in CSV</SPAN>:<BR /><SPAN class="hps">First line:</SPAN> <SPAN class="hps">Table name</SPAN>; <SPAN class="hps">Created</SPAN><BR /><SPAN class="hps">Second line:</SPAN> <SPAN class="hps">Base</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">names</SPAN> <SPAN class="hps">(as in</SPAN> QlikView)<BR /><SPAN class="hps">Third line:</SPAN> <SPAN class="hps">Special</SPAN> <SPAN class="hps">names</SPAN> <SPAN class="hps">(EXW;RTB;SMD;FBV;)</SPAN><BR /><SPAN class="hps">The fourth line</SPAN> <SPAN class="hps">is an empty string</SPAN> <SPAN class="hps">without</SPAN> <SPAN class="hps">records</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">separators</SPAN><BR /><SPAN class="hps">Fifth</SPAN> <SPAN class="hps">row</SPAN>: <SPAN class="hps">table</SPAN> <SPAN class="hps">data itself</SPAN><BR /><BR /><SPAN class="hps">I would be</SPAN> <SPAN class="hps">extremely</SPAN> <SPAN class="hps">grateful for any help</SPAN> <SPAN class="hps">and good</SPAN> <SPAN class="hps">all</SPAN> <SPAN class="hps">day</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Wed, 11 Dec 2013 16:49:18 GMT konkoviv 2013-12-11T16:49:18Z Export Table to csv with a complex structure https://community.qlik.com/t5/QlikView/Export-Table-to-csv-with-a-complex-structure/m-p/560316#M209150 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps"></SPAN><SPAN class="hps"><SPAN lang="en"><SPAN class="hps"></SPAN><SPAN class="hps"><SPAN lang="en"><SPAN class="hps">Good afternoon</SPAN> <SPAN class="hps">dear friends</SPAN>.<BR /><BR /><SPAN class="hps">Problem</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">the following</SPAN> <SPAN class="hps">kind.</SPAN> <SPAN class="hps">I need</SPAN> <SPAN class="hps">to unload</SPAN> <SPAN class="hps">the data</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">in the CSV</SPAN> <SPAN class="hps">(separator ' ; ') </SPAN><SPAN class="hps">But there is one</SPAN> <SPAN class="hps">Problem</SPAN>, I have <SPAN class="hps">the following structure</SPAN> <SPAN class="hps">in CSV</SPAN>:<BR /><SPAN class="hps">First line:</SPAN> <SPAN class="hps">Table name</SPAN>; <SPAN class="hps">Created</SPAN><BR /><SPAN class="hps">Second line:</SPAN> <SPAN class="hps">Base</SPAN> <SPAN class="hps">table</SPAN> <SPAN class="hps">names</SPAN> <SPAN class="hps">(as in</SPAN> QlikView)<BR /><SPAN class="hps">Third line:</SPAN> <SPAN class="hps">Special</SPAN> <SPAN class="hps">names</SPAN> <SPAN class="hps">(EXW;RTB;SMD;FBV;)</SPAN><BR /><SPAN class="hps">The fourth line</SPAN> <SPAN class="hps">is an empty string</SPAN> <SPAN class="hps">without</SPAN> <SPAN class="hps">records</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">separators</SPAN><BR /><SPAN class="hps">Fifth</SPAN> <SPAN class="hps">row</SPAN>: <SPAN class="hps">table</SPAN> <SPAN class="hps">data itself</SPAN><BR /><BR /><SPAN class="hps">I would be</SPAN> <SPAN class="hps">extremely</SPAN> <SPAN class="hps">grateful for any help</SPAN> <SPAN class="hps">and good</SPAN> <SPAN class="hps">all</SPAN> <SPAN class="hps">day</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Wed, 11 Dec 2013 16:49:18 GMT https://community.qlik.com/t5/QlikView/Export-Table-to-csv-with-a-complex-structure/m-p/560316#M209150 konkoviv 2013-12-11T16:49:18Z