Can someone help me with the excel automation!

[supriya117 (Supriya Allada)]

And check this for count values to write in excel: @Suthari_RohithReddy

Count the number of occurrences of each value in an excel column

@Yugal_Raju Please take a look at the following workflow for your understanding: [image] Here, you have a pre-built datatable ‘dtUpdated’ with 2 columns (Value & Count). Then you are executing a query to group similar data. Once the grouping is done, you load a datarow to the dtUpdated with the group value & group count. Input: [image] Output: [image] Hope this helps, let us know if you find any difficulty executing this. Best Regards.