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
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
-
Read the excel file strting from cell A3.
-
Now transpose that table so that Date, period and text become column
-
now u can use sort datatable activity to sort the datatable
-
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
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