I’m trying to write some code to update a very large datatable (100,000 rows) where I have a Transaction Type in a column. Based on the code written in the Transaction Type column I need to update another column. Using a For each works well but it takes 10 minutes to update all the rows, could anyone help me with LINQ or some code I could use to update these rows a lot faster please?
Thank you for your help. I have uploaded a simplified version of what I’m working with.
sample.xlsx (8.5 KB)