Discussions

 View Only

Want to find if a unique 'key' in one table exists in another.

  • 1.  Want to find if a unique 'key' in one table exists in another.

    Posted 05-19-2022 13:26
    I have one table that I can create a unique 'key', which is just a concatenation of a Project ID and Dollar Amount.

    I have another table of 60k records, and I want to see if my 'key' exists in that table. (It may exist a couple times, but unlikely for that key to exist more than 2 or 3 times in the table).

    I cannot figure out how to do this. What I have tried so far:

    1. Formula Query. This failed as I am unable to query the table. It is too large, or something but I get the 'too long to process' error.
    2. Combined text field. I tried to get a combined text field of entries, and then look that up on my initial table and do a simple 'Contains' formula. However, the smallest batch of numbers I can get may be up to 1200 entries. The combined text field only can do up to 150. SO I miss about 1000+ entries.

    My only thought: Figure out a way to compartmentalize the combined text. ie - create 10 combined text fields, somehow broken down in chunks of 150. Then check through all 10 fields for a match.

    That sounds like a lot of work, anyone have a better idea?

    ------------------------------
    Mike Tamoush
    ------------------------------