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 u…

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…

Ya—you might need to do a split of those values, then another multiple relation back to the source container, then another join.

Can you please elaborate - Tried it, but admittedly don’t understand it… How would that result in showing unique results only?

Actually…maybe I misunderstood your request. Does this help: [image] 🗃️ Create a categorized inline list from a master list without UNIQUE formulas Community Resources Take a master list of items with categories and create a parent list of those categories without any spre…

so I ended up implementing a solution I know best. I did a Unique formula in a separate sheet =UNIQUE( {Container# , ProjectName} ) which basically lists the Unique Containers and Projects, then a relation to the Container # in that sheet Lookup to the Project Name Joined the Lookup I…

[image] 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 comfo…

[image] 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

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.

Join Lookup and Show Unique Results Only

Ask for Help

Robert_Petitto October 21, 2021, 10:19pm 4

Actually…maybe I misunderstood your request. Does this help:

Topic		Replies	Views
How to only pull unique values from a list Ask for Help	7	1565	October 1, 2021
How to show Unique Item? Ask for Help	2	194	October 4, 2023
Joined List with only unique values Ask for Help	8	466	January 29, 2024
How do I remove duplicate row in leaderboard Ask for Help	20	546	February 12, 2023
Showing one row of many Ask for Help	14	459	December 29, 2021

Join Lookup and Show Unique Results Only

Related topics