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 SourceTransaction AmountCountDescriptionBank Statement2501BR SunterBank Statement2501Branch Sudirman 1Bank Statement2501Branch Sudirman 2Bank Statement2251BR Sunter 1 Expected SourceTransaction AmountCountDescriptionBank Statement2503BR SunterBank Statement2503Branch Sudirman 1Bank Statement2503Branch Sudirman 2Bank Statement2251BR Sunter 1 This is my currently workflow that i have created in alteryx : Thank you and regards, Lydiea

Count records for some criteria

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

Parse

Accepted answers

grazitti_sapna

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.

Countrecords.yxmd

All comments

grazitti_sapna

Hi @Lydieatantra , try this if it works for you?

Thanks.

Countrecords.yxmd

Lydieatantra

Thanks very much @grazitti_sapna, it works perfectly 🙂

Regards,

Lydiea

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703