topic Re: Pls Suggest in QlikView

Pls Suggest

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

Hi All,

I need to show only duplicate records in the data model

how do we accomplish this??

Kindly help.

Re: Pls Suggest

sunny_talwar — Thu, 02 Nov 2017 11:40:15 GMT

So are you looking to see all those F1 which repeat more than one? or are you looking for F1&F2 than repeat more than once?

Re: Pls Suggest

madhumitha — Thu, 02 Nov 2017 11:48:11 GMT

Hi Antony,

Please check the attached file.

Hope it helps.

Re: Pls Suggest

antonybi — Thu, 02 Nov 2017 12:15:13 GMT

Yes Sunny am just taking dummy data to get the logic.

In my actual data it is completely different.

Can you suggest me on this??

Re: Pls Suggest

sunny_talwar — Thu, 02 Nov 2017 12:24:07 GMT

But what is the final output you are looking to get?

Re: Pls Suggest

antonybi — Thu, 02 Nov 2017 12:32:11 GMT

Only it has to show duplicate records

In data model table should be like this

Re: Pls Suggest

madhumitha — Thu, 02 Nov 2017 12:36:50 GMT

Hi Antony,

Did you check my attachment?

Re: Pls Suggest

sunny_talwar — Thu, 02 Nov 2017 12:39:10 GMT

Try this

temp:

LOAD * Inline [

F1, F2

1, a

2, b

3, c

4, d

5, e

6, f

7, g

8, h

9, i

10, j

];

Right Join (temp)

LOAD F1,

Where Count > 1;

LOAD F1,

F2,

Count(F1&F2) as Count

Resident temp

Group By F1, F2;

Re: Pls Suggest

antonybi — Thu, 02 Nov 2017 12:41:21 GMT

No am unable to open that you've shared as am using PE

Re: Pls Suggest

madhumitha — Thu, 02 Nov 2017 12:45:41 GMT

temp:
LOAD* Inline
[
F1, F2
1, a
2, b
2, b
3, c
4, d
4, d
5, e
6, f
6, f
7, g
8, h
8, h
9, i
10, j
10, j
];

Temp1:
NoConcatenate
Load
*
where Count >1;

Load
F1,F2,
count(F1&F2) as Count
Resident
temp
group by
F1,F2;

drop Table temp;