Datatable update based on column

RachelN · April 24, 2020, 3:17pm

jcastro · April 24, 2020, 3:26pm

Got it. In your testing.xaml use the following code:

testDT.Select("[Export Type]='Import'").ToList().ForEach(Sub(row) row("Export Type")=row("Export Type").ToString.Replace("Import","Export"))

RachelN · April 24, 2020, 3:46pm

Thanks a lot @jcastro

jcastro · April 25, 2020, 7:36am

No worries! I learned something new, too!

RachelN · April 25, 2020, 1:04pm

testDT.Select(“[Export Type]=‘Import’”).ToList().ForEach(Sub(row)row(“Recon”).ToString=row(“Recon”).ToString.Replace(“Bank Data”,“Bank Recon”))

am getting error as “expression is a value and cannot be the target of an assignment”

jcastro · April 26, 2020, 11:45am

Part of the expression is incorrect. It should be:

Sub(row) row(“Recon”)

Remove the .ToString

RachelN · April 26, 2020, 12:53pm

It worked thankyou

system · April 29, 2020, 12:53pm

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.