We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

week to month conversion

pokhan27
8 - Asteroid
‎07-26-2021 11:55 AM



Hi experts

i have a week number in first row and year in second how do i convert  this, can i concatenate row like 2019-12 as single value

 

 

NAME12131415161718192021222324
NAME2019201920192019201920192019201920192019201920192019
Labels:
Reply
1 REPLY 1
rkapoor
Alteryx
Alteryx
‎07-27-2021 01:15 AM

@pokhan27 you can play around with the Transpose and Crosstab to achieve this as per the workflow attached:

RishiK_0-1627373617275.png

Here is some more info on both tools:

https://help.alteryx.com/2018.3/Transpose.htm?tocpath=Tools%7CTool%20Categories%7CTransform%7C_____6....

https://help.alteryx.com/20212/designer/cross-tab-tool#:~:text=The%20Cross%20Tab%20tool%20is,through....

pokhan27.yxmd
Reply
Community Live
Labels
Top Solution Authors
View All