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
Solved! Go to Solution.
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 |
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
I don't find this 3th tool in your example on my Alteryx.
Could you please advise?
@ggermano - Similar to @flying008's solution attached
Hi @flying008 would you mind sharing the workflow with me?
Taking into account the video is exactly what I am looking for!
Thanks,
Guilherme
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!