How to add values of same date and same company

Help
1

Hi All,

here I am attaching sample of my doubt.
I have to sum the values of same company and same date. can anyone help me with this issue.
For example in above sample i 123.xlsx (2.0 MB) have to filter the LIABILITY_COMPANY_GROUP column with one company and check DEPOSIT_DATE column if same date repeated many times then i have to sum up the values of LIABILITY_TAXABLE column values for those same date.

2

Hi @ryava_santhoshi - Please find attached the workflow as you requested. Try it, if works for your then mark this as a Solution to close the raised query.

Thanks,
AK

MatchExcelDT.xaml (16.3 KB)

1 Like
3

Hi @ryava_santhoshi please check below workflow
BlankProcess.zip (627.0 KB)

Regards,
Pathrudu

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.