I have this
For row in dt.Select("[NeedModification] = ‘needFrontEnd’").CopyToDataTable
IF something a = 1,
row([NeedModification]) = “OK”
IF something a = 2,
row([NeedModification]) = “ERROR”
Write dt to CSV
The problem is that when I write dt to CSV, whatever I’d done in the filtered data table was not reflected in dt - meaning “OK” and “ERROR” are not showing in the CSV. The filtered data table is base on [NeedModification] = “needFrontEnd”.
I know I can assign the filtered data table to filterDt = dt.Select("[NeedModification] = ‘needFrontEnd’").CopyToDataTable
And then write filterDT in CSV. But I also want dt to ouput in CSV… This way I may have two CSVs instead which is not ideal.
But can I achieve this without creating a seperate data table output?