Duplication Issue

[Mostafa_Anwar]

Hi All,

i am struggling to achieve this:

i have dataset as per below with duplication values after joining Plan Vs Sales

 

And how i achieve this by removing duplicates value and replace either with blank or Zeros as per below

Thanks a lot in advance!

Regards,

[wdavis]

Hi @Mostafa_Anwar 

I have attached a workflow that achieves what you are expecting. Using the Unique Tool you are able to split out the data into two streams, the top 3 in your example (Unique) and the 1 in the bottom flow (duplicate) that we want to amend the plan value for.

From the bottom flow, we then use a Formula tool to manual change all Plan values to be "0". Then you can union your data set back together so you have all 4 records displaying again.

Let me know if this works for you!

Kind Regards

Will

[wdavis]

Hi @Mostafa_Anwar 

I realised as I uploaded that, that in fact you want to remove values if Sales are the same. Therefore I have included another Duplicate tool before the other, in order to complete remove that value.

I would suggest confirming in the Duplicate tool that you have set up your configuration to ensure these steps are carried out correctly. Let me know if you have any questions on these.

Will

[Mostafa_Anwar]

Thanks Will for your respond,

Basically the provided workflow removed one row For Cisco product as there another Plan value with 90,000 below is the output of the provided workflow So how we can add this plan as well.

Regards,

Mostafa

[wdavis]

Hi Mostafa,

So in your final output, you still require all 4 rows to remain in the dataset? For the Cisco row that was removed, because it had the same sales value, does this just need to have the Sales figure show "0" as we did with the 2nd HP product in the "Plan" Field?

Thanks

Will

[Mostafa_Anwar]

Yes in order to display the plan value

[wdavis · Accepted solution]

I have updated the workflow for you to now incorporate the changing of the Sales figure to represent 0 when there is a duplicate value.

Let me know if you have any further questions

Will