Sorting data in Excel

[Naveen.Ch (NaWin)]

Hi All,
@Palaniyappan @Lahiru.Fernando

1.Trying to add multiple condition for single column to remove the data but its not working(if I add one name for one column its working) - Filter Data Table Activity

2. I want to sort the data in excel column from A to Z

3. and i want to sort the Date from Old to New
   

   

Best Regards,
Naveen

[ppr (Peter Preuss)]

@Naveen.Ch
In your first screenshot you showing a filterdefinition that cannot be fullfillled:
if column2= activated then it cannot be e.g. completed in the same time

not knowing all your requirements, but changing the AND conjunction setting to OR could help you to step out from this issue

[Palaniyappan (Palaniyappan P)]

Hi

@Naveen.Ch

Trying to add multiple condition for single column to remove the data but its not working(if I add one name for one column its working) - Filter Data Table Activity

Use OR condition instead of AND in filter editor

Then for this

@Naveen.Ch

want to sort the data in excel column from A to Z

We can use SORT DATATABLE activity for this

And for this

@Naveen.Ch

and i want to sort the Date from Old to New

Kindly have a view on this

Sort by date and time

Hi guys, How can filtrer data by date and time, which is in this format as a string “05/06/2019 15:34:02” ? Thank you!

Cheers @Naveen.Ch

[balupad14 (Balamurugan (BalaReva))]

Hi @Naveen.Ch,

To sort the data , take a look this one.

Know about Activity : How to sort the data in Excel

Hi , I have shared that how to sort the data in Excel. I have the EmployeeData Excel file. I have to sort data based on bdate column. Before sort the data : [image] After sort the data : [image] Design Screen [image] Sample : ExcelSort.zip (85.9 KB) Regards Balamurugan.S

Regards
Balamurugan.S

[AshwinS2 (Ashwin S)]

Hi @Naveen.Ch

Check this

Sort DataTable based on column value

Hi, I have an Excel looking like this: Column1, Column2, Column3 XX, XX, -1040 XX, XX, -104 XX, XX, -1072 XX, XX, -1087 XX, XX, -111 I want to read this and sort the DataTable based on valuesd in “Column3”. This is the result using when using DataView.Sort(ascending): -104 -1040 -1072 -1087 -111 This is of course not the result im looking for. Does anyone have any idea how i can do this sorting?

Dataview dv=new DataView(Dt)

Dv.Sort=“Column2,Column3,Column4 asc”

Thanks
Ashwin S

Thanks
Ashwin S

[Naveen.Ch (NaWin)]

Hi @Palaniyappan,

Thanks for quick response

Sort Data table is working only for one column
But i want to sort 3 columns in same sheet.

Best Regards,
Naveen

[Naveen.Ch (NaWin)]

Hi @balupad14

Thanks for the response
I am not creating any table so how i can get the table name because the range is not will be same everytime

[Palaniyappan (Palaniyappan P)]

Then we can use macro to do that
Or sort datatable activity one after the another in sequence
Cheers @

[Naveen.Ch (NaWin)]

Hi @Palaniyappan,

I have used sort data table one after another its not working

Best Regards,
Naveen

[Palaniyappan (Palaniyappan P)]

fine
then we can try with macro
@Naveen.Ch

[Naveen.Ch (NaWin)]

Hi @Palaniyappan,

Can you please help to create macro

I don’t know how to write macros

Best Regards
Naveen

[Palaniyappan (Palaniyappan P)]

that would be simple buddy
like open your excel manually and in that click on VIEW option and click on MACRO under which click on RECORD MACRO
–now do the sorting manually in the excel meanwhile that steps will be recorded in the background and will get converted into relevant VB Script
–once after performing the process of sorting in excel at the left bottom of the excel screen we can see a small black square box and on pressing that the macro recording will be stopped.

–now click again on MACRO and VIEW MACRO and EDIT option
–which will open the macro and copy that and paste it in a txt file
–now use a INVOKE VBA activity inside the EXCEL APPLICATION SCOPE and mention the filepath of that txt file as input and method name as well

Cheers @Naveen.Ch