Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Grouping and Multi sheet Reporting (with joining of different tables)

EricaMN
5 - Atom

Hi there,

I am having some trouble with outputting reports. I am experiencing two different issues:

 

I have reports which I need to group by departments but also have multiple sheets which show tables by level.

I am able to get my tables grouped into separate workbooks by department but am not able to get the levels to appear on different sheets.

I have two different workflows where I’ve attempted this:

  1.  below where I separated out the tables by the level and then tried to join and output into multiplesheets

 

EricaMN_0-1632836260595.png

 

 

  1. where I have kept all levels into the tables and am again only finding success in grouping outputs by department, but not creating separate sheets for level.

 

 

 

I am having a similar-ish issue where I can output reports grouping workbooks by department  based on level and when I join with similar reports to the above it will only join the one sheet but no more. Example attached. Sheet 3 is the layout of the table pictured in the workflow.

 

Thank you, any help appreciated!

 

 

 

 

0 REPLIES 0
Labels
Top Solution Authors