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!
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
@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?