Datatable update based on column

[RachelN (Rachel)]

testing.xaml (6.4 KB)

[jcastro]

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

[RachelN (Rachel)]

Thanks a lot @jcastro

[jcastro]

No worries! I learned something new, too!

[RachelN (Rachel)]

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]

Hi @RachelN,

Part of the expression is incorrect. It should be:

Sub(row) row(“Recon”)

Remove the .ToString

[RachelN (Rachel)]

It worked thankyou