Alteryx Designer Desktop Discussions

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

Need help is using the Summarize tool

EmilDem01
8 - Asteroid

i have this table

Sr.IDTypeAmountAdvanceDiscount
123456CREDIT2000500 
123789DEBIT400010 
123789   0.3
123963CREDIT30000
123852CREDIT40001000 
123852   0.25
147852DEBIT80003500 
147852   0.15
159753DEBIT350050.1

 

Results should be like this

Sr.IDCredit_TypeDebit_TypeAmountAdvanceDiscount
123456CREDIT 20005000
123789 DEBIT4000100.3
123963CREDIT 30000
123852CREDIT 400010000.25
147852 DEBIT350050.1

 

3 REPLIES 3
AndrewSu
Alteryx
Alteryx

@EmilDem01 , I think your end state is missing a row for Sr.ID 159753 and that the values for Sr.ID 147852 are actually incorrect (they are the values for Sr.ID 159753 ).

 

I believe the below is what you are looking for as the end state.  

 

AndrewSu_0-1665545042799.png

Please see the attached workflow to see one path to get to this new table. 

 

If this helps resolve your issue, please mark this post as the solution so that other's in the community can benefit from our collaboration. 

 

Thanks. 

 

flying008
14 - Magnetar

Hi, @EmilDem01 

 

1- Maybe there is a easy way like @AndrewSu :

 

录制_2022_10_12_14_03_15_949.gif

 

2- If you have many types like N > 3 more than "CREDIT" and "DEBIT", there is a smart solution to avoid manual fill formula again.

 

录制_2022_10_12_14_59_40_123.gif

 

******

If is can help you get want output, please mark it as s solution and give me a like for more share.

EmilDem01
8 - Asteroid

Thank you soo much ..

This Worked :) 

Labels