Hi All, I am joining two result sets using a left join. But i get duplicate records for a given player. Can you kindly suggest what can be done different here? Please find attached the script.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
use distinct word to remove duplicates first you try to put distinct in first table & remove from 2nd table if your output againn comes with duplicate records then try to put distinct in another table
like below
[IPL-2013]:
LOAD Distinct Player,
Mat,
Inns,
NO,
[Runs Scored],
Highest,
[Batting Average],
BF,
SR as [Batting Strike Rate],
Hundreds,
Fifties,
Ducks,
Fours,
Sixers,
Year,
'Delhi DareDevils' as Team
FROM
Demo.xlsx
(ooxml, embedded labels, table is [Delhi-2013-Batting]);
left join
LOAD Distinct Player,
Mat,
Inns,
Overs,
Mdns,
Runs_Given,
Wkts,
Bowling_Average,
Econ,
SR as [Bowling Strike Rate],
Four_Wicket_Hauls,
Five_wicket_Hauls,
Ct,
St,
'2013' as Year,
'Delhi DareDevils' as Team
FROM
Demo.xlsx
(ooxml, embedded labels, table is [Delhi-2013-Bowling]);
