Render report

Question

Hi All,

I am having 4 different outputs, each of them should be in different tabs in single excel file.

Output 1 - 179K rows, 44 Columns

Output 2 - 450 rows, 22 Columns

Output 3 - Table rendered which has two pivots horizontally.

Output 4 - Table which has 4 horizontal pivots

The output from render tool is perfectly works fine, 100%. But it takes 47 mins to complete.

Suggest me the best way to reduce the time consumption, I already tried enable performance profiling, Disable browse tools, but still same time.

Is there any other alternate to RENDER tool as I heard render tool usually takes longer time?

Please find the screenshot as a reference. Thanks.

mceleavey · Answer

@ppatane , I would also suggest not using Excel for anything, ever.

M.

ppatane · Answer

To get the proper formatting in my output, I gave up on the rendering tool for the reason mentioned above.  I export a plain file to an xlsm file with an auto-executing VBA macro that formats and maybe add the rank function, etc. and then save it down as an xlsx.  Much faster and cleaner

ArnaldoSandoval · Answer

Hi @Sarath27

The performance profiler tell us the time taken by each tool on the canvas to execute; it does nothing to increase performance, we use these time figures to identify the bottlenecks processing the data streams.

Have you processing just the fields required by the workflow's output? sometimes the data stream contains 100 or 200 fields while the output include less than 30 of those fields, then we should prune the workflows of the fields overhead.

And the obvious question asked by @caltang ; the specific reason to use the render tool; We use the render tool when the stakeholder requested a fancy formating, which sometimes (most of the time) could be achieve with Excel macros.

- Arnaldo