Weekly Challenges

T_Willins · ‎11-04-2019

I resolved this from scratch as it was almost a year ago that I first solved this real-life challenge. Much more efficient workflow now. I use this as an example of the power of Alteryx. This used to be a manually copied to Excel process from multiple files that took about 10 hours to complete for over 1500 lines. Now it is seconds.

Spoiler

pgrug · ‎11-04-2019

Thanks for making the challenge!

benakesh · ‎11-04-2019

Spoiler

Initial filter : REGEX_Match([Field_1], '^\|\s{1,2}\d{1,10}\s.*')
Order of data in valid rows : Start with | , 1 or 2 spaces , 1 to 10 digits, space and anything

Initial filter : REGEX_Match([Field_1], '^\|\s{1,2}\d{1,10}\s.*')Order of data in valid rows : Start with | , 1 or 2 spaces , 1 to 10 digits, space and anything

TonyA · ‎11-04-2019

Talk about a real life example! I never would have figured this out from the instructions without seeing the output. This is why when anyone asks for help on the discussion boards we always ask for sample input and sample output.

Sebenius · ‎11-05-2019

Regex is a blast as normal.

Big tip for geting some help with that regex: https://regex101.com/

Spoiler

Regex Used:
Vat No:
.*\|(\d{3}\-\d{2}\-\d{5})\|.*
Data:
^\|\s+(\d+)\s+(..)\s+(\d{4}\-\d{2}\-\d{2})\s+(\d{4}\-\d{2}\-\d{2})\s+([\d,-]+)\s+(..)\s+([\d,-]+)\s+\|

Regex Used:Vat No:.*\|(\d{3}\-\d{2}\-\d{5})\|.*Data:^\|\s+(\d+)\s+(..)\s+(\d{4}\-\d{2}\-\d{2})\s+(\d{4}\-\d{2}\-\d{2})\s+([\d,-]+)\s+(..)\s+([\d,-]+)\s+\|