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!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi Alteryx Team,
Im newby in Alteryx Team, need your advise to how can i create the workflow as my expected below.
Currently i need to record count based on some amount record. I have tried but the result is shown for each record amount based on description.
Current
| Source | Transaction Amount | Count | Description |
| Bank Statement | 250 | 1 | BR Sunter |
| Bank Statement | 250 | 1 | Branch Sudirman 1 |
| Bank Statement | 250 | 1 | Branch Sudirman 2 |
| Bank Statement | 225 | 1 | BR Sunter 1 |
Expected
| Source | Transaction Amount | Count | Description |
| Bank Statement | 250 | 3 | BR Sunter |
| Bank Statement | 250 | 3 | Branch Sudirman 1 |
| Bank Statement | 250 | 3 | Branch Sudirman 2 |
| Bank Statement | 225 | 1 | BR Sunter 1 |
This is my currently workflow that i have created in alteryx :
Thank you and regards,
Lydiea
Solved! Go to Solution.
Hi @Lydieatantra , try this if it works for you?
The reason for count 1 for every record in your current output is you are grouping the records on the basis of description as well but the description is different for all the records therefore giving you distinct count.Please refer to the workflow attached for your referencce.
Thanks.
