Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Rfoot
Contributor III
Contributor III

Straight table to excel with bookmarks

Hi,

 

I have created an automation that simply applys a bookmark, gets straight table data, adds to excel then sends email.

They all seem to be successful as each block has info im expecting.

EG:

Rfoot_0-1691623657918.png

 

but in the Excel sent to my inbox, it is empty except for the column headers.

Rfoot_2-1691624028357.png

 

Strangely I do the exact same method but with far less data the excel populates perfectly.

Rfoot_1-1691623941887.png

 

Is there something I should be aware of with larger datasets? But in fairness its only 400ish rows of data. Pretty standard report.

 

Regards,

Ryan

 

 

Labels (4)
1 Reply
Florentin74
Partner - Creator
Partner - Creator

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.  Use a variable to build the insert statement in and finally use the "Add rows to an excel worksheet table (Batch)" .