Issue in comparing two datatable - Error- option strict on disallows implicit conversions from 'string' to 'integer

Issue in comparing price value from one table result to other table result in a for each activity…

dtTable1.AsEnumerable.Where(Function(row) not String.IsNullOrWhiteSpace(row(“ItemPrice”).ToString) AndAlso CType(row(“ItemPrice”), Integer) <> 0).GroupBy(Function(row) dtTable2(row(0).ToString.Trim)).ToArray

Error is—
option strict on disallows implicit conversions from ‘string’ to ‘integer’

help please.

Hello!

I think the problem might be on this part: CType(row(“ItemPrice”), Integer) <> 0 .
Can you try CInt(row(“ItemPrice”).toString)<> 0 instead?

Use my activity: Power Search Activity - RPA Component | UiPath Marketplace :slight_smile:

We are not able to use if it is not uipath package and a 3.rd party activity.

im trying it… I get back soon.

No changes… its still giving same error.

row(0) from the second table is of type Int too?

its same time as first i think :S.

Can you show how the tables look like ?
I did not understand if row(0) from the second table also contains integers.

image

It is not sufficient to keep in the last part just .GroupBy(Function(row) dtTable2).ToArray?