Join

[NeeruSaini]

[BO Pull]:
LOAD
"Policy Number",
"Legal Entity",
"Original Inception Date",
"Loss Province",
"Broker Number*
"Name* (Aviva)",
"Prod Kpi Line Description",
"Claim Number",
"Date of Loss",
"Reported Date",
"Claim Accident Year",
"Cause of Loss (Source System)",
"Catastrophe Number",
"Name of Client",
"Gross Incurred (Claims)",
"Gross Losses Paid (Claims)",
"V_Gross Current Reserve",
"Gross Recoveries Received (Claims)",
"Gross Expenses Paid (Claims)",
"Claim ID",
"MONTH CLAIM",
"ALREADY UPLOAD"

Right Join

[SAS Pull]:
LOAD
"Policy Number",
underwritingco_name,
cc_rol_addr_state_code,
"Broker Number* 

I need to make a right join with claim number please. How do I do that?
"Name*
"Prod Kpi Line Description",
"Claim Number",
"Date of Loss",
"Reported Date",
"Claim Accident Year",
losscausetype_ac_name,
losscause_name,
"Catastrophe Number",
ll_address_state_code,
"Gross Incurred (Claims)",
RISKTYPE,
"ALREADY UPLOAD",
"Include/Exclude"

[BrunPierre]

Hi@NeeruSaini  check out this link

Combining tables with Join and Keep