topic Getting Duplicate records in Straight Table in QlikView

Getting Duplicate records in Straight Table

vamshi_1241 — Wed, 19 Sep 2018 09:11:05 GMT

Hello All,

I need some help to avoid duplicate records from the straight table. I have gone through some of the posts before posting this but could not help me to get rid of the issue.

In the attached excel, I mentioned sample records of OTBI/CDM, EBS and Salesforce. The join between these three tables will be 'Customer Account Number'. But When I make this to join is giving duplicate records in the report attached. I tried with a composite key but there is nothing difference I see.

The requirement is to show the records where the Network type and Status is different in three tables.

Note: There are no@@ measure all are dimensions.

Could one of you please help me? stalwar1‌

thanks in advance

Re: Getting Duplicate records in Straight Table

Arthur_Fong — Wed, 19 Sep 2018 10:38:42 GMT

Hi Vamshi,

I would prefer to rename all columns into generic names for QV to apply association rules to concatenate tables.

Then, add in the system name in each table to differentiate which system does the record come from.

In the attached file, select the ID and system to show the records with different Network type and Status.

Thanks and regards,

Arthur Fong

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Wed, 19 Sep 2018 11:24:52 GMT

Thanks, Arthur for your immediate response.

I tried the approach which you have give but I do have more columns in CDM tables which should be linked to other (Child) data model.

Moreover, I should show this in a single row.

Thanks,

Vamshi

Re: Getting Duplicate records in Straight Table

Arthur_Fong — Thu, 20 Sep 2018 01:36:17 GMT

Hi Vamshi,

Can you provide a sample qvw?

Thanks and regards,

Arthur Fong

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Thu, 20 Sep 2018 07:07:35 GMT

Attached sample qvw

Thanks,

Vamshi

Re: Getting Duplicate records in Straight Table

sunny_talwar — Fri, 05 Oct 2018 11:18:57 GMT

Because these values are not same on each of the row.... the CDM Master # is repeating

If it were to be one a single row... which of 3 option would you want to see? High? Low? or Medium?

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Fri, 05 Oct 2018 11:26:36 GMT

But it should display like,

CDM | EBS | H1

High Low High

Low Low Medium or High low Medium

Low Low Low

Re: Getting Duplicate records in Straight Table

sunny_talwar — Fri, 05 Oct 2018 11:29:04 GMT

You are showing me three rows? You want one row or 3 rows? I am not sure what you are looking to get?

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Fri, 05 Oct 2018 11:36:17 GMT

I need three rows but based on join it is being populated in records.

The main logic is to show the rows where the network type and status is the difference in three systems.

Re: Getting Duplicate records in Straight Table

sunny_talwar — Fri, 05 Oct 2018 11:42:51 GMT

Can you highlight which three rows do you want for CDM Master # = 123456?

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Fri, 05 Oct 2018 12:13:24 GMT

Row 4 is showing correctly so expecting any two out of remaining 5 rows

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Fri, 05 Oct 2018 12:17:42 GMT

output could be

Re: Getting Duplicate records in Straight Table

sunny_talwar — Fri, 05 Oct 2018 12:34:12 GMT

Any 2? I am not sure I am following it? This was an example where you have 6 rows (1 you are sure, the other 2 you are not). Let's say you have another CDM Master # where you have 12 rows... now how am I suppose to know which rows to pick? (2 for sure and 4 random) . I mean there has to be some logic behind picking the rows you are looking to pick right? I mean how do I even know that you need to pick 3 rows? why not 2 or 4?

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Fri, 05 Oct 2018 13:15:27 GMT

Yes, You are right Sunny.

Attached excel and qvw!

As per the new qvw, it should show only the highlighted rows and remain will go out.

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Fri, 05 Oct 2018 13:29:57 GMT

As per screenshot, it has to show the rows where network type is same in all three columns.

Re: Getting Duplicate records in Straight Table

vamshi_1241 — Mon, 15 Oct 2018 11:23:08 GMT

This was resolved by concatinating three tables and applying Generic load on each column.