Export of segmented reports

Good afternoon community,

I need your help as soon as someone could tell me how I could generate a macro that exports the report keeping the texts of the header and the end but different tables grouped by the first column come out.

Original

Desired departures

The table can change in lines and number of groups but the texts will be the same in any case.

Export Report.yxmd

Macros

Batch Macro

Machine Learning

Iterative Macro

Accepted answers

JosephSerpis

Hi @JSABOGAL you don't need to use a macro to generate the different tables. The reporting tools have a group option that will generate a different table based on the data in a column. I adjusted your workflow to showcase how this can be done. I would recommend the Reporting Interactive lessons to learn more about the reporting tools.

Export Report.yxmd

All comments

JosephSerpis

Export Report.yxmd

JSABOGAL

I was thinking of something like this, where the macro goes through each of the values that need to be grouped, generates the report and does it again, but I haven't been able to get it to work correctly.

JosephSerpis

Just need to tick which field to group on in the Table tool

JSABOGAL

Good afternoon Joseph, I understand the idea but the problem is that it does not work for me since the text entries and the tables cannot be linked to each other since each one comes from different interfaces and sources. When generating them, I join them with the "Union" function and then I can export them, which is why I have no way of being able to link the data as you show it. After the union, all the groupings change and this option is not generated, because the idea is to do it just like the example you placed but they are not aligned

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703