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

Alteryx Designer Desktop Discussions

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

Bucketing data into grouping of same journal combinations

Jasonchen
5 - Atom

Hello!

 

I have a list of journals with millsons of line item, what I am seeking to do is group them in to different buckets if they are following up with the same account combinations eg: Dr Cash Cr Revenue. 

 

Is there any simple tool which can achieve this?

 

I would appreciate the help!

 

Thank you

2 REPLIES 2
apathetichell
20 - Arcturus

Use formula tool to create a partition key (ie  Dr Cash Cr Revenue) then either use summarize to aggregate (group by partition key/sum your field) or do whatever you need to do to process downstream.

Raj
16 - Nebula

You can flag then easily by formula tool

Labels
Top Solution Authors