COMBINE THE TABLE OUTPUT AND EXCEL OUTPUT IN ONE FILE BUT DIFFERENT TAB

Question

Can anyone help me with my challenge? I'm hoping there's a way to combine the output of Render (excel format) and Output data (excel format) in one file but different tab? Appreciate all your suggestions. Thank you.

I attached my sample use case for reference.

SAMPLE.yxmd

kelly_gilbert · Answer

@RD32XU  - the easiest solution would be to convert your 2nd dataset to a table as well. Then, both datasets will be report objects, and you can output both using a Render tool.

If there is a reason why you can't convert that 2nd dataset to a table, please let us know.

This post from @Jonathan-Sherman explains the details of how to set up the Layout and Render tools to output to separate sheets.

SAMPLE - klg - 2021-08-12.yxmd