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.