community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More

"Split" function in formula

Hello,

Tableau has a veru useful "split" function that allows you to split a string with a delimiter and specify the number of the result you want

 

https://onlinehelp.tableau.com/current/pro/desktop/en-us/functions_functions_string.htm

 

Qlik has the same function, subfield : https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

I think this is quite useful and a very standard feature.


Best regards,

Simon

3 Comments
Asteroid

Found this while looking for something else...I usually use the Text to Columns tool https://help.alteryx.com/current/TextToColumns.htm since it's point-and-click, then anything more complicated usually ends up as a Regex Tool.

 

Jonathan

 

Alteryx Partner

Hello Jonathan,

I usually use the TTC tool. However, I have a use case when I have to take the n (variable coming from macro input) result of the split with the y (variable, coming from a macro input)  of the x(variable coming from the macro input)) field.

The TTC tool means split a know field, getting all the results, deselect the one you don't want, etc... while it can be done within a single one simple formula.

And in this use case, it's just a nightmare with the TTC tool.

You might find the Split function contained in this post useful

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Custom-Functions/idi-p/467216#M9578