Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

nagarjuna123
New Contributor II

How to remove duplicate data in Field

Hi Experts,

I have a meeting type code is below...

 

1X1
GRP
3X1
2X1
CCL
Lunch
Dinner

In that data lot of duplicates is there

How to remove the duplicate in a Meeting type code.

Thanks

14 Replies

Re: How to remove duplicate data in Field

I didn't see any duplicate from sample data. But, Qlikview can automatic skip the Duplicates.

surendraj
Valued Contributor

Re: How to remove duplicate data in Field

Use Distinct..

Highlighted
jsf_fasoli
Contributor II

Re: How to remove duplicate data in Field

You can use the LOAD DISTINCT statement on the script to avoid loading duplicate records.

The DISTINCT statement can also be used with Set Analysis to avoid considering duplicates of a field.

nagarjuna123
New Contributor II

Re: How to remove duplicate data in Field

Hii..

my source like below ..

   

Based on the client no of meetings and unique meeting id count needed.

Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                 
1305486H1/12/2017Analyst Marketing DayGRPAXA Inv Mgrs - EuropeEuropean Shares           
Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                 
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                 
1307755H2/15/2017Field TripGRPAmansa CapitalAsian Shares
1320065H3/16/2017Analyst Marketing Day1X1T Rowe Price - Investment AdvisorLatin American Shares     
1310503H3/2/2017Non Deal ManagementGRPBank J Safra SarasinPanEuro Shares             
1320452H3/9/2017Field TripGRPLombard Odier Darier Hentsch & Cie - Private BankPanEuro Shares             
1320452H3/9/2017Field TripGRPBDK Capital SASPanEuro Shares             

      How to get No of meetings and Rank based on the attendee the meeting id in meeting id have a duplicate id

(Check Bold data)

surendraj
Valued Contributor

Re: How to remove duplicate data in Field

Use

Load  Distinct * from

[Table name];

nagarjuna123
New Contributor II

Re: How to remove duplicate data in Field

hi Expets...

How to get No of meetings and Rank based on the attendee the meeting id in meeting id have a duplicate id

I am trying below expression in no of meeting logic   but i am not getting the data

Aggr(count({<[Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client name])

Anybody correct the above expression

Thanks

Re: How to remove duplicate data in Field

Your question is different than this. Where are u trying this?

nagarjuna123
New Contributor II

Re: How to remove duplicate data in Field

Meeting Id

Event DateEvent TypeMeeting Type CodeClient NameProduct Line
161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                
1305486H1/12/2017Analyst Marketing DayGRPAXA Inv Mgrs - EuropeEuropean Shares          
Meeting IdEvent DateEvent TypeMeeting Type CodeClient NameProduct Line
161967P1/24/2017ConferenceDINNERAnbang Asset Mgmt (Hong Kong) Co LtdEconomics
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                
1335933H3/30/2017IMG - Investor Reverse InquiryCCLAesir Capital Mgmt LPUS Shares                
1307755H2/15/2017Field TripGRPAmansa CapitalAsian Shares
1320065H3/16/2017Analyst Marketing Day1X1T Rowe Price - Investment AdvisorLatin American Shares    
1310503H3/2/2017Non Deal ManagementGRPBank J Safra SarasinPanEuro Shares            
1320452H3/9/2017Field TripGRPLombard Odier Darier Hentsch & Cie - Private BankPanEuro Shares            
1320452H3/9/2017Field TripGRPBDK Capital SASPanEuro Shares  

My suorce file above

I am trying below expression in no of meeting logic   but i am not getting the data

Aggr(count({<[Event Type]={'Non Deal Management','Conference','Field Visit','Field Trip','Other GCA','IMG - Investor Reverse Inquiry'}>} distinct [Meeting Id]),[Client name])

Thanks

Re: How to remove duplicate data in Field

That is okay. Which object you tried fir?

Can u remove aggr() and then try for a while

Community Browser