Removing duplicates from a textlist

Question

Hello!Was hoping I can get help with this problem.I'm using a query formula to get a list of emails from another unrelated table and it works just fine, however, it gives me duplicates which i'd like to get rid of somehow. Has anyone dealt with this issue before?example textlist:brucewayne@email.com ; theflash@email.com ; brucewayne@email. com ; brucewayne@email. com ; theflash@email.com; theflash@email.com ; superman@email.comdesired outcome:brucewayne@email.com ; theflash@email.com ; superman@email.comI can either make a new field to get the desired outcome or perhaps there's a way for me to stop duplicates on the query formula?

MarkShnierYou · Answer

The trick is to flag the source record with a flag on the source record as to it its's the Record with the lowest Record ID# of all its "brothers".

I can help with the syntax if need be but pull a text list Query within the source table to pull back all the records with the same email address as the record. Pull in the value of Field ID # 3 which is the Record ID#. into a text list query result then convert to regular text and hive off the leftmost value. That will be the lowest record # of all the brothers with the same email address. Then have an IF statement formula to check if the Record ID# of the brother is the lowest one and if so flag it as OK to pull.

The adjust your current formula query to only pull in ones that are flagged as being OK to pull.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community