Datatable update based on column

testing.xaml (6.4 KB)

Hi @RachelN,

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"))

Thanks a lot @jcastro

No worries! I learned something new, too! :slight_smile:

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”

1 Like

Hi @RachelN,

Part of the expression is incorrect. It should be:

Sub(row) row(“Recon”)

Remove the .ToString

It worked thankyou

1 Like

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