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

[archana.yamijala]

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.

[vignesh.ks]

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

[archana.yamijala]

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

[vignesh.ks]

Hi again @archana.yamijala

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

Thanks.

[archana.yamijala]

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

[archana.yamijala]

Any solution??