Forum Discussion

MikeTamoush's avatar
Qrew Commander
3 years ago

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

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
No RepliesBe the first to reply