Map data 2 file (datarow = 4k)

Help Activities
, ,
1

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.

image
image698×203 8.12 KB

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

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
3

Hi @fairymemay ,

Would this be of help?

image

(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(
	{If(pymt.Count()>0,pymt.First().Item("BILLCHNL").ToString,""),
	If(pymt.Count()>0,pymt.First().Item("SCBFLG").ToString,"")}
	).ToArray()
Select dt_result.Rows.Add(ra)).CopyToDataTable()

LookUpData.xaml (7.6 KB)

Kind Regards,
Ashwin A.K