Hello experts, My Left table has 77MB and Right Table has 27MB, i am trying to pull the maching records from the Left table(Right Join). when i checked output its coming more than 6GB. Doubt on below points please help me * how to get maching records from Left table. * Do i need to unselect left table fields to reduce the size. * if i unselect the left table fields, How can i get the matching records from the Left table Regards, Niranjan

Right Join ( whey Right join has More records )

Hello experts,

My Left table has 77MB and Right Table has 27MB, i am trying to pull the maching records from the Left table(Right Join).
when i checked output its coming more than 6GB.

Doubt on below points please help me

how to get maching records from Left table.
Do i need to unselect left table fields to reduce the size.
if i unselect the left table fields, How can i get the matching records from the Left table

Regards,
Niranjan

Input

Join

Accepted answers

Emil_Kos

Hi @NiranjanK1,

It will not matter the output will be exactly the same. Unless the column names differ and you want to keep the column names from the right table.

If that is the case I would suggest switching left and right connection:

All comments

Emil_Kos

Hi @NiranjanK1,

This post explains really well why you see duplicates here:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-Alteryx-generate-duplicate-rows/m-p/552533/highlight/true#M119745

You are joining the data on the columns that have duplicate positions in both data bases. The easiest way (it isn't best practice) is to use the unique tool in order to remove the positions that are duplicated and keep only one record for the position that you are using in join tool.

In short, you need to clean your data. Remove the duplicate positions and the workflow will work for you.

Please mark my post as a solution if this was helpful for you. If you have more questions please let me know!

NiranjanK1

@Emil_Kos Thanks for your reply

Both the data sources have same set of fields, if im using Right outer join do i need to un select left table fields. im not clear on below points, please suggest me

how to get maching records from Left table.
Do i need to unselect left table fields to reduce the size.
if i unselect the left table fields, How can i get the matching records from the Left table

Regards,

Niranjan

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703