Joining Data

Hi Everyone,

In one file I have 20k rows and in another file, I have 50k rows.

I am looking to join data of file one of reach entry with file two's each row.

can anyone help, how I can do this?

Initially, I created a common key column to match data with each other like in the key column I populated "1" in all rows of both files.

Then joined data by join tool with Key criteria but it took hours to run and showed memory issue.

Is there any way to manage joins with huge data?

Datasets

Macros

Join

Accepted answers

atcodedog05

Hi @SagarGite

You can also use append tool with below config for cross join and use below config for handling large data.

Cross join will take time check whether this method is faster.

Hope this helps : )

cross join.yxmd

All comments

apathetichell

when you join you join each matching entry of each of the two sources. What that means is that if you try to join 20,000 records on 50,000 records each on the value of 1- your resulting dataset would be 20,000*50,000 records. How do you want this to work? usually a key column is a unique value.

SagarGite

Yes this is what I am trying.

Alteryx_AR

@SagarGite Use append tool to get the required result.

Please visit page Append Fields Tool | Alteryx Help for configuration details.

Hope this helps

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703