Joining small table to large table

[mcmb]

Hi All

I've been trying to figure out a way when joining different tables:

Table 1: contains 2000 records

Table 2: contains 1mil records

Only want Table 2 to search for the records that are in Table 1 even before joining them, is this possible?  Otherwise it takes a very long time to run as Table 2 returns all records including the ones that are not in Table 1 when I join the tables. I have tried Dynamic Input but there can be a lot of ids involved.

Thanks in advance.

[Inactive User · Accepted solution]

If performance is an issue you can try the following:

A) Joining on a numerical set of fields only.

B) Find & Replace (Append the new information from Table 1), then filter out nulls for those appended fields.

C) Use In-DB tools to do the joins before putting the data into memory.

[mcmb · Accepted solution]

Thank you

[Cpach]

Hi Ryan, I'm new to Alteryx and have this same issue...only my large table is over 1B records.  Can you expand on B & C?  I haven't used in-DB tools because I don't really understand the concept.

Thank you!