Join

NeeruSaini — Sun, 12 Feb 2023 22:22:34 GMT

[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"

Re: Join

BrunPierre — Sun, 12 Feb 2023 07:03:54 GMT

Hi@NeeruSaini check out this link

Combining tables with Join and Keep

topic Re: Join in App Development

Join

Re: Join