Getting Duplicate records in Straight Table

[vamshi_1241]

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

[Arthur_Fong]

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

[vamshi_1241]

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

[Arthur_Fong]

Hi Vamshi,

Can you provide a sample qvw?

Thanks and regards,

Arthur Fong

[vamshi_1241]

Attached sample qvw

Thanks,

Vamshi

[sunny_talwar]

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?

[vamshi_1241]

But it should display like,

CDM | EBS |  H1

High     Low     High

Low      Low     Medium   or High  low  Medium

Low     Low      Low

[sunny_talwar]

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

[vamshi_1241]

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.

[sunny_talwar]

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