topic Re: Split words from a String in Alteryx Designer Desktop Discussions https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407143#M348985 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/561090">@ankit0412</a>&nbsp;<BR />How about we directly split the string to 5 columns.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="0810-ankit0412.jpg" style="width: 999px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/408951i38653E64A0A4FB67/image-size/large?v=v2&amp;px=999" role="button" title="0810-ankit0412.jpg" alt="0810-ankit0412.jpg" /></span></P> Sat, 09 Aug 2025 23:18:35 GMT Qiu 2025-08-09T23:18:35Z Split words from a String https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407121#M348980 <P>Hello,</P><P>How can I splits Days column into 5 different columns as below</P><P>&nbsp;</P><P>Thank You</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Days</TD><TD>Mon</TD><TD>Tue</TD><TD>Wed</TD><TD>Thr</TD><TD>Fri</TD></TR><TR><TD>M</TD><TD>M</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>MT</TD><TD>M</TD><TD>T</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>MTW</TD><TD>M</TD><TD>T</TD><TD>W</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>MTWR</TD><TD>M</TD><TD>T</TD><TD>W</TD><TD>R</TD><TD>&nbsp;</TD></TR><TR><TD>MTWRF</TD><TD>M</TD><TD>T</TD><TD>W</TD><TD>R</TD><TD>F</TD></TR></TBODY></TABLE> Fri, 08 Aug 2025 23:41:44 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407121#M348980 ankit0412 2025-08-08T23:41:44Z Re: Split words from a String https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407126#M348981 <P>You need to split the word into rows and then cross tab them to get back the tabular data. Attached is the workflow demonstrating the same.</P> Sat, 09 Aug 2025 06:48:09 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407126#M348981 Gaurav_Dhama_ 2025-08-09T06:48:09Z Re: Split words from a String https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407143#M348985 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/561090">@ankit0412</a>&nbsp;<BR />How about we directly split the string to 5 columns.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="0810-ankit0412.jpg" style="width: 999px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/408951i38653E64A0A4FB67/image-size/large?v=v2&amp;px=999" role="button" title="0810-ankit0412.jpg" alt="0810-ankit0412.jpg" /></span></P> Sat, 09 Aug 2025 23:18:35 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407143#M348985 Qiu 2025-08-09T23:18:35Z Re: Split words from a String https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407147#M348986 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/561090">@ankit0412</a>&nbsp;one way of doing this</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="binuacs_0-1754782166876.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/408953i4524C3F09BB4E05E/image-size/medium?v=v2&amp;px=400" role="button" title="binuacs_0-1754782166876.png" alt="binuacs_0-1754782166876.png" /></span></P><P>&nbsp;</P> Sat, 09 Aug 2025 23:29:35 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407147#M348986 binu_acs 2025-08-09T23:29:35Z Re: Split words from a String https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407249#M349009 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/561090">@ankit0412</a>&nbsp;another way would be using the formula tool and if contains e.g</P> <P>&nbsp;</P> <LI-CODE lang="javascript">IIF(Contains([Days], "M"), "M", null())</LI-CODE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2025-08-11 114352.png" style="width: 588px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/408995iBE742035E71593C1/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2025-08-11 114352.png" alt="Screenshot 2025-08-11 114352.png" /></span></P> Mon, 11 Aug 2025 10:44:34 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-words-from-a-String/m-p/1407249#M349009 aatalai 2025-08-11T10:44:34Z