Joining small table to large table

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.

Best Practices

Join

Accepted answers

unknown

If performance is an issue you can try the following:

A) Joining on a numerical set of fields only.

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

Thank you

All comments

unknown

If performance is an issue you can try the following:

A) Joining on a numerical set of fields only.

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

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703