Need help in Download Tool

[EN6924]

Hello All,

Using the Download tool and Regex, I was attempting to retrieve the "List of Alteryx Weekly Challenge names."

URL- https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275

I utilized manual logic in the 5th Step - "Filter tool" because I didn't know how to really retrieve the data that was stored in table format.

If there is a simpler way to go about doing this, please guide me.

Thanks.

[Felipe_Ribeir0 · Accepted solution]

Hi @EN6924 

One way of doing this

1)Looking at the data, the first row of the table will always have the 'Challenge Name' string

2)The table will continue until you dont have '<TR bgcolor=' string anymore

Based on this, i used a multi-row formula to create a column with the value 1 while this condition is met, and filtered it after it. You can use this same logic or find a different pattern to use the multi row formula.

[EN6924]

Perfect 🙂 Thanks for the help