# Join Lookup and Show Unique Results Only **URL:** \ **Category:** Ask for Help\ **Created:** [October 21, 2021, 4:12pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414 "2021-10-21T16:12:34Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eden/32/18651_2.png) [@Eden](https://community.glideapps.com/u/Eden)\ **Post date:** [October 21, 2021, 4:12pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/1 "2021-10-21T16:12:34Z")
So for a Bit of Context; I added a delivery tab in My app to show all upcoming ‘Container’ Deliveries. Each ‘Container’ Contains Multiple ‘Pallets’, Each Pallet belongs to a different “Project”. So I Created a lookup to Show the “Project” for all Related Results, and then a Join, for it to show up as a single line within the ‘Container’. However, Now it shows up as “7871, 7871, 7369, 7871” Instead of my desired result; “7871, 7369” ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 21, 2021, 4:20pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/2 "2021-10-21T16:20:17Z")
Ya—you might need to do a split of those values, then another multiple relation back to the source container, then another join. ---
**Author:** ![Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eden/32/18651_2.png) [@Eden](https://community.glideapps.com/u/Eden)\ **Post date:** [October 21, 2021, 7:16pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/3 "2021-10-21T19:16:00Z")
Can you please elaborate - Tried it, but admittedly don’t understand it… How would that result in showing unique results only? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 21, 2021, 10:19pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/4 "2021-10-21T22:19:55Z")
Actually…maybe I misunderstood your request. Does this help: > [@🗃️ Create a categorized inline list from a master list without UNIQUE formulas](https://community.glideapps.com/t/create-a-categorized-inline-list-from-a-master-list-without-unique-formulas/32824): > > Take a master list of items with categories and create a parent list of those categories without any spreadsheet formulas. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 21, 2021, 11:43pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/5 "2021-10-21T23:43:08Z")
You can do it like this; Add a rowID column if you haven’t done so. Create a relation using the “Project” column, relate that to itself, let it be a multiple match. Have a single value column, let’s name it “First ID”, return the first rowID from the Project relation above. Have an If Then Else column, if rowID is “First ID”, then return the project number associated with the row. Finally, using a joined list, you can return all the “First ID” from the multiple relation in step 2. ---
**Author:** ![Eden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eden/32/18651_2.png) [@Eden](https://community.glideapps.com/u/Eden)\ **Post date:** [October 25, 2021, 3:43pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/6 "2021-10-25T15:43:47Z")
so I ended up implementing a solution I know best. 1. I did a Unique formula in a separate sheet `=UNIQUE( {Container# , ProjectName} )` which basically lists the Unique Containers and Projects, 2. then a relation to the Container # in that sheet 3. Lookup to the Project Name 4. Joined the Lookup I did if for 2 reasons, 1. It’s more familiar territory, 2. Row ID might be an issue since the Containers sheet is an IMPORTRANGE. as for performance, the Unique formula shouldn’t be too heavy and only updates when new containers are added, so it’s not too bad. I’m wondering what your thoughts are on that. @ThinhDinh @Robert_Petitto Thank You so much for your help with this! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 25, 2021, 3:56pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/7 "2021-10-25T15:56:52Z")
Ya, that works just fine. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 25, 2021, 3:58pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/8 "2021-10-25T15:58:21Z")
> [@Eden](#): > > as for performance, the Unique formula shouldn’t be too heavy and only updates when new containers are added, so it’s not too bad. > I’m wondering what your thoughts are on that. I think that’s fine. I’ve used a similar approach in the past - although I wouldn’t now as I’m comfortable with the option that @ThinhDinh described. > [@Eden](#): > > 1. Row ID might be an issue since the Containers sheet is an IMPORTRANGE. It wouldn’t be, as long as you leave it at the end of the sheet as the last column. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [October 25, 2021, 4:00pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/9 "2021-10-25T16:00:28Z")
> [@Darren\_Murphy](#): > > It wouldn’t be, as long as you leave it at the end of the sheet as the last column. It would, though, if the data coming in inserts/removes/rearranges rows ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 25, 2021, 4:13pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/10 "2021-10-25T16:13:25Z")
I guess it depends what you’re using the RowID’s for. In this case, the only important thing is that they remain unique - which they would, even if data is added or removed. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [October 26, 2021, 8:30pm UTC](https://community.glideapps.com/t/join-lookup-and-show-unique-results-only/33414/11 "2021-10-26T20:30:51Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.