Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Condense four records into one record

KSassone
8 - Asteroid

I have the following output data, but I need it to be reflected as one record, and not four, with the Grand Total.

I can de-select the Trans Date no problem, but I need to have the data consolidated into one record.

 

Current Records:

ItemDescriptionUOMDept NameTrans DateSUNMONTUEWEDTHUFRISATGrand Total
1203COVER SHOE XTRC SMS XL 3 PLYBXGENERAL SURGERY5/26/202000300003
1203COVER SHOE XTRC SMS XL 3 PLYBXGENERAL SURGERY5/27/202000040004
1203COVER SHOE XTRC SMS XL 3 PLYBXGENERAL SURGERY5/28/202000006006
1203COVER SHOE XTRC SMS XL 3 PLYBXGENERAL SURGERY5/29/202000000101

 

Suggested Record:

ItemDescriptionUOMDept NameSUNMONTUEWEDTHUFRISATGrand Total
1203COVER SHOE XTRC SMS XL 3 PLYBXGENERAL SURGERY003461014

 

Can anyone give me some ideas on how I can do this? 

Very much appreciated !!

Kiri

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @KSassone I mocked up a workflow let me know what you think?

jeff_reynolds
10 - Fireball

Hi there. This is a perfect job for the summarize tool. See attached workflow as an example. 

 

Good luck!

 

 

KSassone
8 - Asteroid

Thank you @JosephSerpis  and @jeff_reynolds !  I knew there was an Alteryx solution - am so embedded in this project that I couldn't see for the trees !

Labels