We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #262: With-invoice

Jonny
11 - Bolide

hard one, got a solution of my own, but not the most iterative probably.

rmassambane
9 - Comet

Another one that bites the dust!

amir_alteryx_2021
6 - Meteoroid

No macros were hurt during this solution and also I utilized the save and reload from the select tool to bypass the titles which was a pain

JasonHu
8 - Asteroid
Spoiler
workflow1.png

Here is my submission. did long time ago, but forgot to submit.

ncrlelia
11 - Bolide

Challenge 262

DawnDuong
12 - Quasar
12 - Quasar

I think the "start" file should state that the number of dashes = number of characters in each columns as typically in "fixed width" export (which is common but not always the case for such exported formats).

 

FredNajjar
8 - Asteroid

The file structure tripped me out, but there is nothing you can't do with REGEX! 

 

Spoiler
Screenshot_3.png
youngk313
8 - Asteroid

Long parsing

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

  • The ley to this challenge is a simple RegexReplace, you need to identify what is a comfortable range of single whitespace characters that can come together between columns, for me it came out to be 17 that sufficed both so the RegEx Replace would look like \s{2,17} which would replace any white space counting between 2 to 17 to a character of choice which you can then delimit with.
  • Always remember Data Cleansing towards the end is very helpful when working with unstructured data

Do not remove punctuation if you aren't sure of data types, because . is treated as a punctuation if data type is string and it can be catastrophic working with numeric fields

  • Try to keep things dynamic else you'll end up spending hours using a select tool and lose the purpose of the exercise
Spoiler
Solution_262.PNG
GarryBrittain
6 - Meteoroid

done and done!

 

Spoiler
GarryBrittain_0-1626151418525.png