topic Re: Which tools needs to be used? in Alteryx Designer Desktop Discussions https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Which-tools-needs-to-be-used/m-p/883987#M213624 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/296372">@selinunlu</a>&nbsp;,</P><P>&nbsp;</P><P>How to make it is concatenate by using Formula tool and Concatenate by using Summarize tool and then join by using Join tool.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_0-1640440723283.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216074i736FC1CCB01464C2/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_0-1640440723283.png" alt="AkimasaKajitani_0-1640440723283.png" /></span></P><P>Sample Input :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_2-1640440764895.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216076i78B714F9C0CDEAE5/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_2-1640440764895.png" alt="AkimasaKajitani_2-1640440764895.png" /></span></P><P>&nbsp;</P><P>Formula tool setting</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_1-1640440747004.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216075iD623974520E294E3/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_1-1640440747004.png" alt="AkimasaKajitani_1-1640440747004.png" /></span></P><P>&nbsp;</P><P>Summarize tool setting :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_3-1640440793754.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216077iE0F254884ED61714/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_3-1640440793754.png" alt="AkimasaKajitani_3-1640440793754.png" /></span></P><P>&nbsp;</P><P>Join tool setting:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_4-1640440810086.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216078i55342C22669FBC0A/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_4-1640440810086.png" alt="AkimasaKajitani_4-1640440810086.png" /></span></P><P>&nbsp;</P><P>Result :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_5-1640440824982.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216079iE2A893BBC73FF3D7/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_5-1640440824982.png" alt="AkimasaKajitani_5-1640440824982.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 25 Dec 2021 14:00:37 GMT AkimasaKajitani 2021-12-25T14:00:37Z Which tools needs to be used? https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Which-tools-needs-to-be-used/m-p/883859#M213623 <P>Hello, hI need to acquire right hand side green column. Which tools I should use respectively?</P> Thu, 13 Jun 2024 21:29:20 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Which-tools-needs-to-be-used/m-p/883859#M213623 selinunlu 2024-06-13T21:29:20Z Re: Which tools needs to be used? https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Which-tools-needs-to-be-used/m-p/883987#M213624 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/296372">@selinunlu</a>&nbsp;,</P><P>&nbsp;</P><P>How to make it is concatenate by using Formula tool and Concatenate by using Summarize tool and then join by using Join tool.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_0-1640440723283.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216074i736FC1CCB01464C2/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_0-1640440723283.png" alt="AkimasaKajitani_0-1640440723283.png" /></span></P><P>Sample Input :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_2-1640440764895.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216076i78B714F9C0CDEAE5/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_2-1640440764895.png" alt="AkimasaKajitani_2-1640440764895.png" /></span></P><P>&nbsp;</P><P>Formula tool setting</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_1-1640440747004.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216075iD623974520E294E3/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_1-1640440747004.png" alt="AkimasaKajitani_1-1640440747004.png" /></span></P><P>&nbsp;</P><P>Summarize tool setting :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_3-1640440793754.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216077iE0F254884ED61714/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_3-1640440793754.png" alt="AkimasaKajitani_3-1640440793754.png" /></span></P><P>&nbsp;</P><P>Join tool setting:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_4-1640440810086.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216078i55342C22669FBC0A/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_4-1640440810086.png" alt="AkimasaKajitani_4-1640440810086.png" /></span></P><P>&nbsp;</P><P>Result :</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AkimasaKajitani_5-1640440824982.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/216079iE2A893BBC73FF3D7/image-size/medium?v=v2&amp;px=400" role="button" title="AkimasaKajitani_5-1640440824982.png" alt="AkimasaKajitani_5-1640440824982.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 25 Dec 2021 14:00:37 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Which-tools-needs-to-be-used/m-p/883987#M213624 AkimasaKajitani 2021-12-25T14:00:37Z