topic Re: how to reduce the duplicate records in section access in QlikView

how to reduce the duplicate records in section access

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Devps,

how can i reduce duplicate of rows in following group table when i asign more then one city to users(manager or excutive) , in my original db i have 10 to 20 citys for a single user,so do i need to duplicate 20 rows or is there any method to handle in a single row

match(city,'HYD','BNG')

i have attached the sample file and db modal please check once.

Section Access;

LOAD * INLINE [

ACCESS, UserID, ORDER,ROLEORDER

ADMIN,ADMIN,1,1

USER,MANAGER,2,2

USER,EXCUTIVE,3,3

USER,SUPERVISOR,4,4

];

Section Application;

STAR is *;

Group:

Load * Inline [

ORDER,CARCITY,BIKECITY

1,*,*

2,"HYD","HYD"

2,"BNG","BNG"

3,"HYD","HYD"

];

Cars:

LOAD * Inline [

Carname,CARCITY,CARPERSON

Honda,HYD,NARSIMHA

HERO,HYD,NARSIMHA

Maruti,BNG,PRASAD

Maruti,KOlKOTTA,PRASAD

];

Bikes:

LOAD * Inline [

BikeName,BIKECITY,BIKEPERSON

Honda,BNG,NARSIMHA

Tvs,HYD,PRASAD

Tvs,KOlKOTTA,PRASAD

];

Re: how to reduce the duplicate records in section access

vinieme12 — Fri, 31 Mar 2017 10:02:56 GMT

use left join ! from User to City that is it

Re: how to reduce the duplicate records in section access

Anonymous — Fri, 31 Mar 2017 10:16:35 GMT

user means the group table u mean ? can you please write query once

Re: how to reduce the duplicate records in section access

Peter_Cammaert — Fri, 31 Mar 2017 10:21:40 GMT

If you already have those Cities listed per User in your DB, then why don't you just make a copy of this database table and call it Group?

Re: how to reduce the duplicate records in section access

vinieme12 — Fri, 31 Mar 2017 10:31:45 GMT

like below

Group:

Load * Inline [

ORDER

];

left join(Group)

Carcity:

Load ORDER,

Subfield(CARCITY,',') as CARCITY

Inline [

ORDER,CARCITY

1,"*","*"

2,"HYD,BNG"

3,"HYD,BNG,MUM"

];

Re: how to reduce the duplicate records in section access

Anonymous — Fri, 31 Mar 2017 10:38:36 GMT

hi peter,

i can call it from database but i need to reduce the number of rows for a single user in the above group table i marked the rows duplicating when user having more then one city so how to reduce from 2 rows to one row

Re: how to reduce the duplicate records in section access

Anonymous — Fri, 31 Mar 2017 12:57:07 GMT

Thank you vineeth its worked