https://community.qlik.com/t5/Qlik-Automate/Straight-table-to-excel-with-bookmarks/m-p/2104370#M2281 <P>If you have a loop over recipients, remember to close the workbook session for each loop and remember to delete the excel table as well.&nbsp; Use a variable to build the insert statement in and finally use the "Add rows to an excel worksheet table (Batch)" .&nbsp;</P> Thu, 10 Aug 2023 07:24:11 GMT Florentin74 2023-08-10T07:24:11Z https://community.qlik.com/t5/Qlik-Automate/Straight-table-to-excel-with-bookmarks/m-p/2104257#M2280 <P>Hi,</P> <P>&nbsp;</P> <P>I have created an automation that simply applys a bookmark, gets straight table data, adds to excel then sends email.</P> <P>They all seem to be successful as each block has info im expecting.</P> <P>EG:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rfoot_0-1691623657918.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/114003i7226CE3EE461AAD8/image-size/medium?v=v2&amp;px=400" role="button" title="Rfoot_0-1691623657918.png" alt="Rfoot_0-1691623657918.png" /></span></P> <P>&nbsp;</P> <P>but in the Excel sent to my inbox, it is empty except for the column headers.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rfoot_2-1691624028357.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/114005i9C4ADDAEC355E94D/image-size/medium?v=v2&amp;px=400" role="button" title="Rfoot_2-1691624028357.png" alt="Rfoot_2-1691624028357.png" /></span></P> <P>&nbsp;</P> <P>Strangely I do the exact same method but with far less data the excel populates perfectly.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Rfoot_1-1691623941887.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/114004iE727480D98AB35E7/image-size/medium?v=v2&amp;px=400" role="button" title="Rfoot_1-1691623941887.png" alt="Rfoot_1-1691623941887.png" /></span></P> <P>&nbsp;</P> <P>Is there something I should be aware of with larger datasets? But in fairness its only 400ish rows of data. Pretty standard report.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Ryan</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 09 Aug 2023 23:39:38 GMT https://community.qlik.com/t5/Qlik-Automate/Straight-table-to-excel-with-bookmarks/m-p/2104257#M2280 Rfoot 2023-08-09T23:39:38Z https://community.qlik.com/t5/Qlik-Automate/Straight-table-to-excel-with-bookmarks/m-p/2104370#M2281 <P>If you have a loop over recipients, remember to close the workbook session for each loop and remember to delete the excel table as well.&nbsp; Use a variable to build the insert statement in and finally use the "Add rows to an excel worksheet table (Batch)" .&nbsp;</P> Thu, 10 Aug 2023 07:24:11 GMT https://community.qlik.com/t5/Qlik-Automate/Straight-table-to-excel-with-bookmarks/m-p/2104370#M2281 Florentin74 2023-08-10T07:24:11Z