Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Spoiler
2 versions:
First using the Dynamic Rename tool to create the field headers from the first row's data.
Second using the embedded select in the RegEx tool. Still needed another select to remove the first column though.
First using the Dynamic Rename tool to create the field headers from the first row's data.
Second using the embedded select in the RegEx tool. Still needed another select to remove the first column though.
Whew, this one was fantastic practice. I'm still a RegEx beginner and I know there are way more efficient ways than using six RegEx tools, but it's all part of the learning journey. 😊
argh! i got lost in Regex! kudos to @johnemery 's fantastic video, made me start again and go at it step by step.
Spoiler
Learnt a few new tricks like data cleansing all the letters from the sales columns, and Dynamic Rename for the column headers
