Append data more columns?

[Stef_99 (Mary)]

Append data?

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

@Ajay_Mishra From previous topic
Old req.
I want copy from column A- I , column Y and column J-V

New Req.
I want copy from column A- I , column Y ,column J-V ----> Append to column A
and copy column AA ----> Append to column AM

If I want more copy column AA and append data in column AM in another file.

Please guide me about it.

Please guide me about it.

[Ajay_Mishra (Ajay Mahendra Mishra)]

@Stef_99 Okay, can you share me input file and output file it will be better for me to understand your requirements?

Regards,
Ajay Mishra

[Ajay_Mishra (Ajay Mahendra Mishra)]

@Stef_99 Please send it once again

Regards,
Ajay Mishra

[Stef_99 (Mary)]

@Ajay_Mishra ok , I send to you in message again already.

Thank you

[Ajay_Mishra (Ajay Mahendra Mishra)]

@Stef_99

I want copy from column A- I , column Y ,column J-V ----> Append to column A
and copy column AA ----> Append to column AM

If I want more copy column AA and append data in column AM in another file.

Please guide me about it.

Please guide me about it.

Hey @Stef_99

If you have these many conditions, I suggest you take some time and use the below-mentioned query,

Assign Activity:

dt_Input = dt_Input.DefaultView.ToTable(False,{"All Column Names", "According", "to your requirements"}).AsEnumerable.OrderBy(Function(r) r("Start")).CopyToDataTable

Note: In the above query pass column names according to your arrangement.

This will be easy and you can manage the position for any column!

Below I’m providing you with all the column names that you need as output, for copy-pasting the column names

{"Status","Owner","SR #","SR Service ID","Account","SR Category","SR Sub Category","SR Issue","Detail","SR Detail","SR Product Line","SR Owner Name","Create Division Name","SR Product Type","SR Due","Planned End","Activity #","SR Committed","Account Type","Create ID","Create Name","SR Opened","Planned Start","Activitiy Closed Date","SLA VS Planed Start (day)","SLA VS Opened Date (day)","SLA VS Planed Start Raking","SLA VS Opened Date Raking","Owner_BPR","BAN ","Complaint Month","Investigate Result","จำนวนเบอร์ / ประสานงาน","Resolution Type","Complaint Group ","Resolution","Reason ผลการตรวจสอบ
","Sub -Reason ผลการตรวจสอบ","Manager Name","Month","Remark 1","Remark 2
เคสประสานงาน ระบุวัน SR Open วันที่ส่งประสานงาน  วันที่ตามงาน"}

Arrange the columns accordingly and pass in the above LinQ.

Regards,
Ajay Mishra