We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Help with question

gayathri27
7 - Meteor

Can you advice on the best solution. I started with append and join but the join is not working for the line details and line categories dataset.

4 REPLIES 4
geraldo
13 - Pulsar

@gayathri27 

 


to help you, it will be better to export the workflow and attach the yxdb file  to make it easier

gayathri27
7 - Meteor

I tried to follow along your workflow that you attached but I think the dataset is different. could you pls use the dataset I attached and explain to me.

gayathri27
7 - Meteor

I have attached the fields that I used for summarize and the final output .

As per the expected final output they have only 10 records and in my final output I have 13 records.

Any help is appreciated. Thanks !

geraldo
13 - Pulsar

@gayathri27 

 

how are you!
If I understand what you want, your summary tool is configured wrong,
to have the desired output it must be with group by Transactions_ID concatened Vendors and Transfer Methods and if it has more fields than the print did not show also concatened

Labels
Top Solution Authors