Experian Data Quality Community
-
Challenge 6 - Postcode Formatting
This challenge came from a question that I was asked recently. The user had a column of UK postcodes looking something like this: Input file: https://us.v-cdn.net/6031645/uploads/OC3E52MACREK/postcodes.csv The challenge is to reformat these values based on strict requirements, and provide 2 new output fields containing: 8…
-
New challenge ideas
If you have ideas for future challenges/puzzles/scenarios, please let us know as we're always looking for new ideas!
-
Challenge 5 – Fibonacci Sequence to X
The Fibonacci Sequence is the series of numbers 0, 1, 1, 2, 3, 5, 8, 13, 21, 34,.... The next number is found by adding up the two numbers before it. - the 2 is found by adding the two numbers before it (1+1) - the 3 is found by adding the two numbers before it (1+2) - the 5 is (2+3) - and so on! Despite seemingly…
-
Challenge 5 Solutions
So did you figure it out? What approach did you take? Something like this - what was your route to getting there? Post your solution below in the comments (remember to include a screenshot 📷 or a video 🎦 walk-through of your solution so others can see as well as the .dmx file containing the function/workflow containing…
-
Challenge 4 Solutions
So did you figure it out? What approach did you take? You know what the results should look like, but how did you get there? Post your solution below in the comments (remember to include a screenshot 📷 or a video 🎦 walk-through of your solution so others can see as well as the .dmx file containing the function/workflow…
