topic Re: How to export each rows from straight table to text file? in QlikView https://community.qlik.com/t5/QlikView/How-to-export-each-rows-from-straight-table-to-text-file/m-p/675160#M245142 <HTML><HEAD></HEAD><BODY><P>To all readers, fortunately, I was able to solve this problem. Please find attached files for your reference!</P><P></P><P>PSEUDOCODES:</P><OL><LI>Check if file destination is exist</LI><LI>If No, then Exit</LI><LI>If Yes, then Check if row data is Qualified to export to text file</LI><LI>If Qualified, then create each row a text file</LI><LI>If Not Qualified, then loop or continue next record</LI></OL></BODY></HTML> Thu, 23 Oct 2014 18:27:12 GMT bill_mtc 2014-10-23T18:27:12Z How to export each rows from straight table to text file? https://community.qlik.com/t5/QlikView/How-to-export-each-rows-from-straight-table-to-text-file/m-p/675159#M245141 <HTML><HEAD></HEAD><BODY><P>Hi everyone!</P><P></P><P>I have this macro development, I need to export each rows from straight table to text file, depending on the remarks... </P><P></P><P>Sample data below:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ID</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">NAME</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">AMOUNT</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">REMARKS</TH></TR><TR><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">Leroy</TD><TD style="padding: 2px;">100007</TD><TD style="padding: 2px;">Qualified</TD></TR><TR><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">George</TD><TD style="padding: 2px;">50008</TD><TD style="padding: 2px;">Not Qualified</TD></TR><TR><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">Bill</TD><TD style="padding: 2px;">890027</TD><TD style="padding: 2px;">Qualified</TD></TR><TR><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">Scottie</TD><TD style="padding: 2px;">8922</TD><TD style="padding: 2px;">Not Qualified</TD></TR><TR><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">Ringer</TD><TD style="padding: 2px;">19800</TD><TD style="padding: 2px;">Qualified</TD></TR><TR><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">LG</TD><TD style="padding: 2px;">67882</TD><TD style="padding: 2px;">Qualified</TD></TR></TBODY></TABLE><P></P><P>If above data will be the basis, following are instructions:</P><OL><LI>Extract each row into text file, name the text file according to each ID</LI><LI>Extract only rows of data if REMARKS is "Qualified"</LI><LI>Expected total number of extracted textfile is 4.</LI></OL><P></P><P></P><P>Looking forward for your ideas..</P><P></P><P></P><P>Regards,</P><P>Bill</P></BODY></HTML> Wed, 22 Oct 2014 05:59:04 GMT https://community.qlik.com/t5/QlikView/How-to-export-each-rows-from-straight-table-to-text-file/m-p/675159#M245141 bill_mtc 2014-10-22T05:59:04Z Re: How to export each rows from straight table to text file? https://community.qlik.com/t5/QlikView/How-to-export-each-rows-from-straight-table-to-text-file/m-p/675160#M245142 <HTML><HEAD></HEAD><BODY><P>To all readers, fortunately, I was able to solve this problem. Please find attached files for your reference!</P><P></P><P>PSEUDOCODES:</P><OL><LI>Check if file destination is exist</LI><LI>If No, then Exit</LI><LI>If Yes, then Check if row data is Qualified to export to text file</LI><LI>If Qualified, then create each row a text file</LI><LI>If Not Qualified, then loop or continue next record</LI></OL></BODY></HTML> Thu, 23 Oct 2014 18:27:12 GMT https://community.qlik.com/t5/QlikView/How-to-export-each-rows-from-straight-table-to-text-file/m-p/675160#M245142 bill_mtc 2014-10-23T18:27:12Z