Identifying duplicates based on several criteria

[Newsense2020]

Hi experts,

I am quite new to qlik sense and am seeking for help from experts in this forum.

Beneath is an examplary table. We have several customers with individual "Nr". Those are assigned to "Groups". As well we have some information on the customer As "Name 1", "Name 2" and "Street". 

Nr	Name 1	Name 2	Street	Group
1254	Oliver	Kahn	Alphastreet	111
1376	Oliver	Kahn	Alphastreet	222
5432	Oliver	Kahn	Betta Street	222
6543	Philipp	Lahm	Fleet Street	111
2222	Michael	Ballack	Drown Street	111
3333	Thorsten	Frings	Zero Road	222

The following rules should be applied: If somebody has the same "name 1", "name 2" and "Street", this is one person.

My intention would be to create an additional field based on the given information as identifier and link the information Nr. and Group. Here an example:

Identifier	Nr	Name 1	Name 2	Street	Group
Oliver Kahn Alphastreet	1254; 1376	Oliver	Kahn	Alphastreet	111;222

Could anyone help me?

[jonathandienst]

In a table, use Name 1, Name 2 and Street as dimensions. Then use the measures:

Name: Nr,   Expression: Concat(DISTINCT Nr, ';')

Name: Group Expression: Concat(DISTINCT Group , ';')

[Taoufiq_Zarra · Accepted solution]

Maye be :

Data:

LOAD * INLINE [
    Nr, Name 1, Name 2, Street, Group
    1254, Oliver, Kahn, Alphastreet, 111
    1376, Oliver, Kahn, Alphastreet, 222
    5432, Oliver, Kahn, Betta Street, 222
    6543, Philipp, Lahm, Fleet Street, 111
    2222, Michael, Ballack, Drown Street, 111
    3333, Thorsten, Frings, Zero Road, 222
];

output:

load [Name 1], [Name 2],concat(Nr,';') as Nr, concat([Group],';') as [Group], [Name 1]&' '&[Name 2] &' '& Street as Identifier resident Data group by  [Name 1], [Name 2], Street
;

drop table Data;

[Newsense2020]

@Taoufiq_Zarra : That was what I was looking for. Thank you!