My Requirement is i have an excel and i need to first group them according a column and then sort them , i have grouped them and getting a list of datatable and later using for each for list of datatable
Now i need to sort them based on custom sort and then normal sort for another column i.e., sort within a sort
*First need to custom sort based on the attachted list
Custom sort list
Within that sort based on Name column in ascending order
Then delete designation column and merge name and location column headers and rename as Years(based on grouping done)
Any suggestions @Yoichi @ppr @Palaniyappan
Thanks in advance
Hope the following helps you.
dictOrder = dtSortList.AsEnumerable.ToDictionary(Function(r) r(0).ToString(),Function(r) dtSortList.Rows.IndexOf(r))
dt = dt.AsEnumerable.OrderBy(Function(r) dictOrder(r("Designation").ToString)).CopyToDataTable()
Sample20220702-1.zip (12.6 KB)
@Yoichi thankyou it worked!!!
But @Yoichi one problem if there are values which are not present in that custom sort list then its throwing error
If value isn’t in sort list, how do you want to handle it, first or last etc.
@yoichi at last!! least priority
Can you try the following expression?
@yoichi it worked thanks sir!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.