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,

Workflow

Accepted answers

wdavis

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

Duplicates.yxmd

All comments

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

Duplicates.yxmd

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

Duplicates.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703