How to clean duplicate transactions with multiple criteria?

[ggermano]

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.

Please see attached the example for reference.

Could you please help me on this?

Thanks,

Guilherme

[flying008]

Hi, @ggermano 

What's your logic ? want output like this ?

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.

[Bren_Spill · Accepted solution]

@ggermano - Similar to @flying008's solution attached

[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_Spill , 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!