Hello,
Now I have code as below.
dt_Input.DefaultView.ToTable(False,dt_Input.Columns.Cast(Of DataColumn).AsEnumerable.Where(Function(dc) dt_Input.Columns.IndexOf(dc)<22 Or dt_Input.Columns.IndexOf(dc)=24).Select(Function(x) x.ToString).ToArray()).AsEnumerable.OrderBy(Function(r) r("Start")).CopyToDataTable
If I want copy from column A- I , column Y and column J-V
How to edit your code?
Thank you
Just Keep above code after that take a invoke code activity and put
io_dt_Input.Columns("Time Rules").SetOrdinal(10)
Argument: io_dt_Input type: Datatable Value: dt_Input
Screenshot for your reference:
Regards,
Ajay Mishra
io_dt_Input.Columns(io_dt_Input.Columns.ColumnCount-1).SetOrdinal(10)
Use above query it is according to your requirement!
Regards,
Ajay Mishra
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.