Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Summarize a project in one row

hellyars
13 - Pulsar

I have projects down and companies across.  The intersection is how a company segments a give project.  A company may segment the same project 1 or more ways.    


In the first table, there is more than 1 record for a given project if one or more companies want to segment it.

 

How can I summarize each project in one row?

 

Data In...

 

PROJECTCOMPANY_ACOMPANY_BCOMPANY_CCOMPANY_DCOMPANY_ECOMPANY_F   
3041ATacos        
4567X Juice X     
4567X Milk X     
4567X   X     
9878C     Cars   

 

 

Desired Outcome...

 

PROJECTCOMPANY_ACOMPANY_BCOMPANY_CCOMPANY_DCOMPANY_ECOMPANY_F   
3041ATacos        
4567X Juice, Milk X     
9878C     Cars   
          

 

 

4 REPLIES 4
JagdeeshN
12 - Quasar
12 - Quasar

Hi @hellyars ,

 

I think a summarize tool should do this for you.

 

Please find attached a sample workflow that showcases the same.

 

Please do let me know if this helps.

 

Best,

Jagdeesh Narayanan

hellyars
13 - Pulsar

@JagdeeshN  I know.  That's how I go to this point.  This approach forgets to combine Milk with Juice.  

hellyars
13 - Pulsar

Got it.  sum using regular concat + transpose + split to rows using "," + unique + sum using regular concat + cross tab.

hellyars
13 - Pulsar

Here is a solution...

 

Screen Shot 2021-02-12 at 3.13.29 PM.png

Labels
Top Solution Authors