How to clean duplicate transactions with multiple criteria?

Hi Community,

I have an INTERNAL Report that contain Unique Transactions but each of this transactions can became more than one INVOICE.

I created a workflow to join the internal report with the invoices report but I am struggling with the alteryx tools to get the duplicated amounts removed.

Duplicated amounts.png

Please see attached the example for reference.

Could you please help me on this?

Thanks,

Guilherme

Duplicated amounts.xlsx

Workflow

Designer Cloud

Accepted answers

Bren_Spill2

@ggermano - Similar to @flying008's solution attached

Duplicates.yxmd

All comments

flying008

Hi, @ggermano

What's your logic ? want output like this ?

录制_2024_06_19_09_04_04_876.gif

Input
Transaction Number	Entered Amount Due Original	Nº NFS-e	Valor dos Serviços	NUM_NF	VALOR_TOTAL_ITEM
AVOMOH-2024-01	4718.96	7510	4680.54	5475	37.49
AVOMOH-2024-01	4718.96	7510	4680.54	5746	0.92
AVOMOH-2024-01	4718.96	7834	4680.54	5475	37.49
AVOMOH-2024-01	4718.96	7834	4680.54	5746	0.92

Output
Transaction Number	Entered Amount Due Original	Nº NFS-e	Valor dos Serviços	NUM_NF	VALOR_TOTAL_ITEM
AVOMOH-2024-01	4718.96	7510	4680.54	5475	37.49
AVOMOH-2024-01				5746	0.92

ggermano

Hi @flying008 ,

Yes that is right!

Each transaction number can have multiple N NFS-e and NUM_NF, So I would like to return exactly as you show in your video.

Thanks,

Guilherme

ggermano

I don't find this 3th tool in your example on my Alteryx.

Could you please advise?

flying008

Hi, @ggermano

FYI.

录制_2024_06_20_10_12_06_994.gif

Bren_Spill2

@ggermano - Similar to @flying008's solution attached

Duplicates.yxmd

ggermano

Hi @flying008 would you mind sharing the workflow with me?

Taking into account the video is exactly what I am looking for!

Thanks,

Guilherme

flying008

Hi, @ggermano

My solution approach is similar to that of @Bren_Spill2 , except that the additional steps are to dynamically maintain the names and order of field columns without the need for manual adjustment
Due to security policy restrictions, I am unable to upload any WF. Please try it yourself by following the animation. Best Regard!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703