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

Help Studio
, , ,
1

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.

2

Hello!

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

3

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

4

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

5

im trying it… I get back soon.

6

No changes… its still giving same error.

7

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

8

its same time as first i think :S.

9

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

Latif (Robin) 10

image

11

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