This week was an exciting challenge - data scaffolding! When I first heard of this, it went right over my head. But actually, it's a really clever way of appending one data source to another - definitely worth knowing! Check out the challenge here. So why go through all this hassle? What's the point of … Continue reading Week 3 Challenge #preppindata
Week 2 Challenge #preppindata
This week I had to re-do the workflow and go back on some steps to get to the most efficient solution. What did I learn this week? No Sample tool With my background in Alteryx, the first thing I wanted to do was use the “sample” tool to get rid of the first 2 rows … Continue reading Week 2 Challenge #preppindata
Week 1 Challenge #preppindata
For the first week, the solution was pretty straight forward. Nevertheless, there were still some learning points for me! Learning points: 1. When creating a calculated field in Prep, you cannot use the SUM function. I vaguely remember being taught this at the data school but I hadn't used Prep for quite a while - … Continue reading Week 1 Challenge #preppindata