Getting duplicate records from left join

Sat, 25 May 2013 04:19:45 GMT

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

Re: Getting duplicate records from left join

vikasmahajan — Sat, 25 May 2013 09:56:34 GMT

attach demo xls so that some body can help you

Re: Getting duplicate records from left join

er_mohit — Sat, 25 May 2013 11:00:40 GMT

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

topic Re: Getting duplicate records from left join in QlikView

Getting duplicate records from left join

Re: Getting duplicate records from left join

Re: Getting duplicate records from left join