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.
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!
The data I'm trying to join has week number such as 201501, 201502, and so on. My other data source has separate year and week columns so I create a formula (ToNumber(ToString([Year],0) + ToString([Week],0))) to make it the same format as the other data source.
And here's my question:
Data Source 1 week number format:
Data Source 2 week number format (The one I combined year and week columns)
Is there any ways to make 1 digit week number to 2 digits week number so I can join them togehter?