by The Data School | Oct 27, 2023 | The Data School
This week I have been practising my SQL skills with the Week 2 Case Pizza Run in 8 Week SQL Challenge. In this blog I would like to introduce you to the function of STRING_SPLIT to split a column into rows (with MS SQL Server).When preparing the data for analysis, we...
by The Data School | Jun 20, 2022 | The Data School
What do data and coffee have in common? Quite a lot when you think about it! For example they both: Are not consumable in their raw state Will require some altering Can be highly addictive In our first week at The Data School Down Under we began using and learning...
by Grace Murphy | Jun 3, 2019 | Grace Murphy
The text to columns tool in Alteryx can sometimes be a little clunky. It’s a quick fix when you need each element of ‘Element1/Element2/Element3’ to be in it’s own column, but what if the string was ‘Element1/ Element2_ Element3 ’? This requires multiple...
