Alteryx designer Discussions

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

Different chart for different grouping

Highlighted
Meteor

Hi

 

I have a workflow that combines both chart and table. These two layouts will appear differently whenever I group them according to the receiver (VENDOR NAME). Table works fine for me but chart wasn't. By the end of the workflow, I need to send the VENDOR NAME an email containing both charts and table.

 

I have tried to do grouping in the chart but resulting in 4 records instead of 2 since I want to group the details according to VENDOR NAME which have only two persons. Do you have any idea how to fix it?

 

Much appreciate it,

Highlighted
Pulsar

Try using a Join instead of an Append, joining on VENDOR NAME.  Should give you just the two records:

image.png

Highlighted
Meteor

Hi @danrh,

 

I tried to join as you said but it turns to 0 records. Can you attach your whole workflow?

Highlighted
Pulsar

Yep, see attached.

Labels