Cannot perform '=' operation on System.String and System.Int32

Help Activities
, ,
1

Hi ,

I have been filtering datatable and storing values in datarow but while it reaches the last datarow it always throws the error as Cannot perform ‘=’ operation on System.String and System.Int32.

I am not able to figure out the exact cause. Please suggest options.

image

image

2

Hi @archana.yamijala

Try giving like below:

“[Customer]='”+Cust_DB_CF.Rows(iCommonInc)(0).ToString.Trime+“'”

add single quote next to = and at last before closing doubt quote.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

3

I tried with your method but it says cannot find column 0. I need value from it as [Customer]= 123142

It is throwing error in drcommon assign and not in cmnstring assign activity

4

Hi again @archana.yamijala

Can I know, what you are expecting to select in drCommon assign activity.

Thanks.

5

I need datarow (drcommon) to be assigned array values from master_df_cf datatable basis cmnstring (customer= xxxx ) filter.

I am getting output for all the datatable rows except the last one and it is failing there

image

6

Any solution??