https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709899#M166324 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/22097">@hellyars</a>&nbsp;</P><P>Very similar to <a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/85461">@Maskell_Rascal</a>&nbsp; solution, so maybe its the corrent solution.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="0128-Related_B.PNG" style="width: 641px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/167457i1489EC5F9C7B4C28/image-size/large?v=v2&amp;px=999" role="button" title="0128-Related_B.PNG" alt="0128-Related_B.PNG" /></span></P> Wed, 27 Jan 2021 22:34:08 GMT Qiu 2021-01-27T22:34:08Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709881#M166316 <P>I have a list of widgets. &nbsp;I want to create Related_B so that it returns the ID of any record that shares a value under PrdctNmbr. &nbsp;See below...</P><P>&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>ID</TD><TD>PrdctNmbr</TD><TD>Related_B</TD></TR><TR><TD>1</TD><TD>9878,4675</TD><TD>6</TD></TR><TR><TD>2</TD><TD>1324</TD><TD>7</TD></TR><TR><TD>3</TD><TD>5467,4657,9870</TD><TD>&nbsp;</TD></TR><TR><TD>4</TD><TD>6579</TD><TD>7</TD></TR><TR><TD>5</TD><TD>4679</TD><TD>&nbsp;</TD></TR><TR><TD>6</TD><TD>9878</TD><TD>1</TD></TR><TR><TD>7</TD><TD>1324,6579</TD><TD>2,4</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Wed, 27 Jan 2021 21:53:57 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709881#M166316 hellyars 2021-01-27T21:53:57Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709882#M166317 <P>Hi hellyars,</P><P>&nbsp;</P><P>Try out this workflow.</P> Wed, 27 Jan 2021 22:08:14 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709882#M166317 PHinkel 2021-01-27T22:08:14Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709887#M166320 <P>Hi&nbsp;<a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/22097">@hellyars</a>&nbsp;</P><P>&nbsp;</P><P>Something like this would work.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Maskell_Rascal_0-1611785634934.png" style="width: 400px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/167454i0595E7E731053D20/image-size/medium?v=v2&amp;px=400" role="button" title="Maskell_Rascal_0-1611785634934.png" alt="Maskell_Rascal_0-1611785634934.png" /></span></P><P>&nbsp;</P><P>See attached workflow.&nbsp;</P><P>&nbsp;</P><P>If this solves your issue please mark the answer as correct, if not let me know!</P><P>&nbsp;</P><P>Thanks!</P><P>Phil</P> Wed, 27 Jan 2021 22:16:05 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709887#M166320 Maskell_Rascal 2021-01-27T22:16:05Z https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709899#M166324 <P><a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/22097">@hellyars</a>&nbsp;</P><P>Very similar to <a href="https://community.alteryx.com/t5/user/viewprofilepage/user-id/85461">@Maskell_Rascal</a>&nbsp; solution, so maybe its the corrent solution.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="0128-Related_B.PNG" style="width: 641px;"><img src="https://community.alteryx.com/t5/image/serverpage/image-id/167457i1489EC5F9C7B4C28/image-size/large?v=v2&amp;px=999" role="button" title="0128-Related_B.PNG" alt="0128-Related_B.PNG" /></span></P> Wed, 27 Jan 2021 22:34:08 GMT https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Identify-related-records/m-p/709899#M166324 Qiu 2021-01-27T22:34:08Z