How to sort dates column-wise

Help Studio
1

Sorting dates.xlsx (10.7 KB)

Hi all,

I need to sort the dates based on the customer ID. The dates are present in different application columns in excel. I need to pick any two oldest dates for that particular row.

image

This above picture in the input file. I want the output file to look like the picture below.

image

So along with the two oldest dates, I need to pick the column name also.

please help. I need to complete this urgently.

2

Hello,
I have created an excel macro to populate the above specified output which u can call on uipath.
To continue using uipath you can call execute macro activity (PopulateData method in script) with in excel application scope.

image
image1280×1024 103 KB

image
image1280×1024 96.8 KB

image
image1280×1024 95.5 KB

Screenshots attached here with the step flow I followed and got output.
Drop me ur email id, so that I can share xlsm file, if u need.

Hope it helps you.

2 Likes
3

Hi,

Hope the following helps you.

Sample20200525-1.zip (29.2 KB)

Regards,

2 Likes
4

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