This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!
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
@pokhan27 you can play around with the Transpose and Crosstab to achieve this as per the workflow attached:
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....