Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.
SOLVED

Segregate data Monthly basis

AS
8 - Asteroid

Hi Experts,

Here is the table I have to segregate data on monthly basis what could be the best way to do it without mentioning the month 

 

Department: NameTypeMonth
000Bill PaymentOct 2021
000PaymentDec 2021
000PaymentJan 2021
000PaymentOct 2021
000JournalJan 2021
000PaymentJan 2021
6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

Hi @AS 

 

Any thought on what your expected output should look like 😅

saisaranv
7 - Meteor

Any sample data as output? which columns are expecting in Output?

AS
8 - Asteroid

Hi ,

Please found attached tables-

 

Department: NameAmountTypeMonth
0003400Bill PaymentOct 2021
0002320PaymentDec 2021
00034320PaymentJan 2021
000223PaymentOct 2021
000454JournalJan 2021
0004454JournalDec 2021

 

The Expected Output-

 

Department: NameType

Jan

Oct

Dec

000Bill Payment 3400 
000Payment343202232320
000Journal454 4454
atcodedog05
22 - Nova
22 - Nova

Hi @AS 

 

Here is how you can do it.

Workflow:

atcodedog05_1-1646397032706.png

 

Hope this helps : )

AS
8 - Asteroid

thank you so much @atcodedog05 that is really helpful. 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @AS 

Cheers and have a nice day!