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