This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
Reject
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.
community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

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 #348: Reorder a List of Names

EN6924
9 - Comet
‎12-08-2022 03:59 AM

My Solution -

 

EN6924_0-1670500744274.png

 

My_Solution.yxmd
Reply
0 Likes
priyasmilysri
5 - Atom
‎12-08-2022 03:59 AM
Spoiler

priyasmilysri_0-1670500680190.png

 

Challenge 348.yxmd
Reply
0 Likes
DenisZ
11 - Bolide
‎12-08-2022 04:11 AM

Here is my solution

 

 

 

Spoiler
DenisZ_1-1670501411346.png

 

 

 

challenge_348_DZ.yxmd
Reply
0 Likes
Felipe_Ribeir0
15 - Aurora
‎12-08-2022 05:08 AM
Spoiler
My solution, i am using the formula tool to check if we have a comma, and if we have, using findstring and substring formula to rebuild the name:

Felipe_Ribeir0_0-1670504883991.png

 

challenge_348_start_file_desktop_user.yxzp
Reply
0 Likes
JBarr
8 - Asteroid
‎12-08-2022 06:16 AM

Done.

Challenge_348_Solution_JBarr.yxmd
Reply
0 Likes
NathalieHP
7 - Meteor
‎12-08-2022 07:03 AM

My solution on Desktop:

Spoiler
NathalieHP_0-1670511710469.png

 

Has anyone managed to import the Cloud Designer start file?

challenge_348_completed_file_desktop_user.yxmd
Reply
0 Likes
Coakles
6 - Meteoroid
‎12-08-2022 07:38 AM

Pretty straightforward with Text to column.

Coakles_0-1670513868889.png

 

 

challenge_348_start_file_desktop_MCoakley.yxmd
Reply
0 Likes
Prasanth_CS
5 - Atom
‎12-08-2022 08:25 AM

Spoiler

Spoiler
Al_challenge.PNG
Reply
0 Likes
MilindG
11 - Bolide
‎12-08-2022 08:41 AM
Spoiler
MilindG_0-1670517702900.png

 

Solution 348.yxmd
Reply
0 Likes
Jasond2022
6 - Meteoroid
‎12-08-2022 08:43 AM

For us newbies, can you explain what your RegEx did exactly? I don't have much experience with it, so to see this done so simply is very impressive. 

Reply
0 Likes