Report Designer - Table Consolidation

Question

Hello!

I'm new to using Alteryx (and this community) so I apologize if this a junior question.
I did reference some other support articles and haven't been able to get my answer.

I have the workflow working fine and manipulating data without issue.
I'm trying to merge each table into a single report.

Ultimately in the sample data below, you see I have two sets of data, "Standard" and "Federated".
I need to display both of these as tables on a single PDF.

I'm running into a problem where the report puts each row as an individual table.
I tried the grouping options, and get unexpected results.

Is this more an issue with the workflow, or a report design setup issue?

I appreciate the help!

Sample Data:

Amount of federated users of reward_platform_prod :  0
-----------------------------------------------------------------------------------
Amount of federated users of zond :  1
-----------------------------------------------------------------------------------
Amount of federated users of riskproof_production :  32
-----------------------------------------------------------------------------------
Total products:  3
------------------- Gathering nonfed  ----------------------------------------------
Amount of standard users of nv_iam:  169
-----------------------------------------------------------------------------------
Amount of standard users of aspen:  374
-----------------------------------------------------------------------------------
Amount of standard users of ranger_prod:  160
-----------------------------------------------------------------------------------
Total products:  3

Output:

User Counts.yxmd

messi007 · Answer

@jchedrick,

Please see below :

Totally agree with @Luke_C I suggest you to read your file without header.

Hope this helps !

Regards,

User Counts.yxmd

Luke_C · Answer

Hi @jchedrick

You should union the counts before creating the table rather than unioning each table after it's created.

As a side note, I'd suggest reading in the text file with the 'First Row Contains Field Names' option unchecked. A lot of your workflow is based on a field name called [Amount of federated users of nv_iam : 134] which presumably is 1) data you want and 2) subject to change, meaning each tool would need to be reconfigured in the future.