Replace particular column value of data table

Help Studio
, ,
1

Dear Forum members,

I have scenario where i have a data table with 4 column. And I want to replace the particular column value with another value.

for ex. i have 4 column in my data table, like

name income city company
John 200 USA ABC
Deo x AFR PZX
Bro 500 AMR GHJ
Brew x IND APR

So i want that in income column where is exactly “x” then should be replace with some another value.

Please help, if any linq query for this.

Thankx in advance

2

Hi @Yankit_singh
it is possible by this way

Read the excel and store in dt1

then use the invoke code activity with dt1 as in/out argument

dt1.AsEnumerable().Where(Function(row) row(“income”).ToString.Equals(“x”)).ToList().ForEach(Sub(row) row(“income”)=value)

here value is where u need to put the value to replaced with x

Regards,
Nived N
Happy Automation

1 Like
3

@NIVED_NAMBIAR Thankx for reply

I have tried this way. it’s giving an error like

No compiled code to run
Expression is not an array or a method, and cannot have an argument list. At line 1

Thankx

4

I think you need to change the type to Vb.net

5

Can u share the screenshot pls?

6

Hi @NIVED_NAMBIAR

Thankx for response, it’s worked for me.

1 Like
7

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