MikeTamoush
3 years agoQrew Commander
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
------------------------------
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
------------------------------