Dashboard Week Day 1

by Ruth Amarteifio

First day of dashboard week. I created an iterative macro to scrape data from the Asos website to visualise in Tableau.

The two most useful pieces of RegEx I used were:

The non greedy expression .*? to get clumps of data between fields: for example <article.*?

And

Using [a-z’-]* instead of \w* so that i could capture any number of words separated by hyphens.

It worked out perfectly in the end, but took waayyyyy longer than expected, so while it was an exciting day of Alteryx, the dashboard…

Avatar

Ruth Amarteifio

Fri 23 Aug 2019

Thu 22 Aug 2019

Wed 21 Aug 2019

Tue 11 Jun 2019