How to display Duplicate records !!!!!

[#1]

Hi All

Can any one help me how to display duplicate records in front end.

tab1:

Id    name

1     robert

2     john

innerjoin

tab2:

id    lastname

1     jack

2     dev

1     ford

1     das

output is:    id     Name           Last Name

                 1       robert           jack

                 1       robert            ford

                 1       robert            das

now i need to see those 3 ones in front end please help me....

[its_anandrjs]

You are using right inner join see the load script

tab1:

LOAD * Inline

[Id,    name

1,     robert

2,     john

];

inner join

tab2:

load * Inline

[Id,    lastname

1,    jack

2,     dev

1,     ford

1,     das

];

And on table box plot values

Id, name, lastname

And why you want to display only those 3 values.

[alexandros17]

tab1:

LOAD * Inline [

Id,    name

1 ,    robert

2 ,    john

];

inner join

tab2:

LOAD * Inline [

id,    lastname

1 ,    jack

2 ,    dev

1 ,    ford

1 ,    das

];

You can show data with a table or a chart (in this case add as expression the value 1)

[#4]

Hi Alessandro

I Think There is no concept of right inner join in qlikview...

[#5]

Add a expression field in a straight table - =RowNo()

[maxgro · Accepted solution]

create a straight table chart with

dim

Id,    name, lastname

expression

if(count(TOTAL <id> name)>1, 1)

you can hide the expression in presentation tab

[alexandros17]

What do you mean with right inner join??

The instruction I gave to you is a inner join so only matching records on matching fields will be taken

[#8]

Thank you Massimo.

[#9]

Thank you all.

[#10]

why dont you just concatenate id and lastname as calculated dimension and hide it