@Swara_Soni I have used Join Datatables Activity to join the Datatables based on the Condition that you have provided. It yields the output you need but not entirely as the values that you need to be in First Two Columns will be found in it’s duplicate Columns, as Join Datatable Activity does that by default if the Column Names are same.
Hence I have used Linq queries to determine the empty values of First Column that are present after joining to retrieve those values and Shift the values to the first two columns.
But this workflow does provide you the same output as you needed, but although it’s not in the order that you need.
Check this workflow: Revert back if you face any issues and Try the workflow for all kinds of data that you have.
The logic might not be entirely right, but we can try to fix it later based on the errors found. GroupByAndSum.zip (9.6 KB)
Thanks for the workflow @supermanPunch
but when i am running the workflow in actual data it is merging the data tables but not putting values of common columns in same row
i am attaching the file here containing the sample data where the workflow is not working Groupby and match.xlsx (11.6 KB)
The colored rows are the output rows which should be merged in one row.
@Swara_Soni ok. From the data that you have shown in the image, as you can see that there are two spaces after April in the 3rd row and one space after April in the 12th row, that is the reason it is treating it as different rows, Is that going to be the same always, or is that a Typo mistake ?, If that’s going to be the same always, then we would have to First replace multiple spaces with a Single Space and then perform the operation