Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Weekly Challenge Index & Welcome (Page 1)

JXLee
5 - Atom

TQ

stefano_m
6 - Meteoroid

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!

stefano_m
6 - Meteoroid

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
6 - Meteoroid

Hi All,

 

Anyone, could you please help me solve this exercise-1? I have been trying to resolve this issue but all my tries are unsuccessful. 

 

Man007_0-1679942621269.png

 

tammybrown_tds
8 - Asteroid

@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.

Man007
6 - Meteoroid

Hello Tammybrown_tds,

 

 

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?

 

Man007_0-1680205447853.png

 

 

tammybrown_tds
8 - Asteroid

@Man007  

 

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.

Man007
6 - Meteoroid

Please find the file attached here.

 

 

tammybrown_tds
8 - Asteroid

tammybrown_tds_0-1680206541514.png

 

That paragraph ^^ refers to this:

 

tammybrown_tds_1-1680206580375.png

 

You have to change RowCount to [area].

 

Then it will work.

Man007
6 - Meteoroid

You are the best.

I missed the bottom part. Thanks for pointing that out. Now it works as expected. Thank you