Sort datatable

I have sorted excel by date row in excel how do I add below values of the date in datatabledata-WPS Office.xls (11 KB) .if I sort the date the below value of the date should also sorted below the correct date

Hi @sruthesanju

Can u share of how u need the output?

data-WPS Office.xls (11 KB) the output should be sorted in ascenting order.here I have mention only 3 rows but it will have many rows with data

Hi @sruthesanju

I think u can try this approach

  1. Read the excel file strting from cell A3.

  2. Now transpose that table so that Date, period and text become column

  3. now u can use sort datatable activity to sort the datatable

  4. Now transpose it again and thus it beomes in original mode with being sorted and then write to the excel starting with cell B4

(i think for transposing there is activity in uipath )
Hope you got the logic,

Regards,

Nived N

Happy Automation

1 Like

Can you explain me with code

Hi @sruthesanju

Check this workflow

For transposing the datatable i had used the below activity
NovigoSolutions.TransposeDataTable.Activities

sample workflow.zip (4.0 MB)

Mark it as solution if it resolves ur query

Regards,

Nived N

Happy Automation

It works