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 actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Hello fellow community members! I know we all have our preferred methods for keeping track of relevant challenges, but I wanted to share a simple yet powerful analytic app I've developed to make the process even smoother.
This app is designed to easily download and parse the webpage containing the table of challenges. What sets it apart, though, are the interactive interface tools I've included, which allow you to filter by tags and specific data points. With these features, you can quickly identify the weekly challenges that best align with your interests and goals.
I hope you find it as useful as I have, and I welcome any feedback or suggestions for improvements. Let's continue to support each other in tackling these challenges and growing together!
Happy challenge hunting!
I added in some tracking features where the user can use a list box and indicate which new weekly challenges they completed. Old and newly completed challenges are unionid for a concise log of completed challenges... Thoughts?
I also designed it so you can input and track people at one time and keep separate completion logs for each individual.
@Man007, two issues.
In your Create New Field box, you have the new field named [area]. So Alteryx thinks that the brackets are part of your new field name, but in a formula, Alteryx will put brackets around a field name automatically. So in the Condition Expression, Alteryx doesn't recognize [area] as a field name. It's going to look for a field named area (no brackets), and not find it.
If you fix that, you'll get another error that says that "RowCount" is an unknown variable. That is because you don't have RowCount as a field name in your data set. Alteryx defaults the Loop Expression to be RowCount on the generate rows tool, but you have to change RowCount to whichever field you want to increment from. In your case, it would be the 'area' field. So if you change RowCount to [area], it should work for you.
Thanks Very much for reviewing my solution and sharing your opinion on top. I applied all the changes you have mentioned but it is not working as expected. Would you kindly review one time my solutions please?
I can't see the bottom of the configuration screen on your Generate Rows tool, but if you are still getting the error that RowCount is an unknown variable, you must not have changed [RowCount] to [Area] in your Loop Expression. I'm just guessing though, because I can't see the bottom of your configuration window.
That paragraph ^^ refers to this:
You have to change RowCount to [area].
Then it will work.
You are the best.
I missed the bottom part. Thanks for pointing that out. Now it works as expected. Thank you