Multiple Joins. Is it possible?If yes, what are the considerations?

[rively90]

Hi,

Wondering if I can join these files with County + State as PK in EEO Cleaned Data V4 - Random 10% Sample

while County + State as FK in other datasets

How to accomplish this? If so, what are some potential issues/drawback from performing this join? Thanks!

[aatalai]

yes it is called the join multiple tool https://help.alteryx.com/current/en/designer/tools/join/join-multiple-tool.html#join-multiple-tool

Let me know if that helps

[Qiu]

@rively90 
We can use the Join Multiple tool but the PK and FK in the 4 data source are not unique, therefore the data will grow rapidly.

Is this what you expected?