Today we had to visualise data about battlefield sites in the U.K. using data from Historic UK. It has been a long and tiring day; I’ve never used so much Regex before
What have I learnt today…
- Multi-row formula can save you so much time, (I never used it before) but I’m considering adding it to my favourites
- Regex_Replace is my new best friend, initially we had problems but we’re now on a level battlefield
- If you’re Regex isn’t working but it looks completely fine and you’ve tested everything else, try adding a data cleansing tool after the Regex tool. This will remove any leading and trailing whitespaces, which might have been the issue
Okay now, I’ll show you my Regex-y Alteryx workflow:
![](https://www.thedataschool.co.uk/content/images/wordpress/2019/06/Battlefield-Workflow-1024x176.png)
Once I exported all the data, I had about 2 hours to create a dashboard. This is the end result:
![](https://www.thedataschool.co.uk/content/images/wordpress/2019/06/Battlefield-Image-1024x612.png)
Even though today was tough, it challenged me and as a result I learnt so much!