Map data 2 file (datarow = 4k)

I want map data and write it.
My data have 4K rows.

Now I use for each row —> I think it slow.

My input as below.

I want read value in column APAPNO and map in file data

And write data in sheet input column PAYMENT_METHOD and column Flag Y/N —> Follow red text

Remark :

  1. column PAYMENT_METHOD in sheet input = column BILLCHNL from sheet data
  2. column Flag Y/N in sheet input = column SCBFLG from sheet data

Please guide me about it.

Data.xlsx (8.9 KB)
Input.xlsx (11.3 KB)

1 Like

Hi @fairymemay ,

Would this be of help?


(From row In dt_output.AsEnumerable()
Let pymt = dt_input.AsEnumerable().
	Where(Function(w) w("APPNO").ToString.Trim.Equals(row("APAPNO").ToString)).ToArray()
Let ra = row.ItemArray.Take(3).Concat(
Select dt_result.Rows.Add(ra)).CopyToDataTable()

LookUpData.xaml (7.6 KB)

Kind Regards,
Ashwin A.K