Render tool where few sheets are table and few are plain data

[Suraj2742]

I have built a solution where i am generating 10 sheets, 5 sheets has huge data like near to a million rows where if i am using table tool its taking a long tp run the flow and render the output. have already removed data which are not required including columns and used trim tool as well. Last option i thought of not using the table tool for those tabs where data is huge but in render i am not able to generate the output. Is there a way anyone can help? 

[apathetichell]

---

like a million rows is wrong --- excel fits 1,000,000 rows. But having said that --- you cannot do what you are trying to do just with Render. Render conks out around 50K rows in a single sheet.

What you have to do:

1) create all sheets with render --- for your larger sheets you will ONLY create the headers. 

2) after creating all sheets --- you will use an output data to output over the sheets you created in render with your raw data.

No. I do not have a sample I will share with you - sorry.