inner join optimization or alternative

hi Alteryx Community!

I am trying to perform what would be a WHERE statement or an INNER JOIN in SQL language and I am using the Join tool and only outputting the "J" output. However both the original data (.csv) and the list of values to filter out (.xlsx) are quite large and thus performance is really bad. Is there a better alternative to perform this operation?

Thank you!

Datasets

Accepted answers

afv2688

Did them in the end 🙂

Cheers

filter_workflow.yxmd

filter_macro.yxmc

All comments

afv2688

Hello @janez_007 ,

Since you are trying to perform a where statement I would recommend you to filter all unnecessary rows using a filter tool. Use this option only if you are sure about the rows which you are not going to use.

Reducing the amount of columns on the embbeded select tool within the join would also help the general performance. Once again, being sure about those which are not going to be used.

Cheers

janez_007

hi afv2688,

thank you for your reply. Are you just suggesting to reduce the size of the original data for faster processing or is there a way to use a filter with a list of values from a different data source?

thank you.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703