Getting duplicate records from left join

[#1]

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.

Thanks,

Ram

[vikasmahajan]

attach demo xls so that some body can help you

[er_mohit]

Try this

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]);