If "excel's first row contains the data which comes from ExtractDataTable's first row"

[Pikachu_KH]

Hi Everybody!

I have a sequence which I do data scraping and then I read an Excel. After that, I have an if activity, which I want to use a condition like “‘not’ excel’s first row contains the data which comes from ExtractDataTable’s first row”. Is there any code like this? Or how can I do this with other ways?

Thank you!

[Srini84 (Srinivas Kadamati)]

@Pikachu_KH

You can check the condition as

ExtractDataTable.Rows(0).Item("ColumnName") = YourValue

Check below for your reference too

RPA DataTable: Get Previous Row Column Value, Set to Current Row Column Value

sorry i can not use this solution… As I want to Read Next row value before i continue to regiser the current row… my issue is When i have done reading current row through if statement … then I want to know… the next row Category before continue… And if there is no category or no row in table which has Category … then it should continue and register the current row in systerm… But it giving me error when it there is no row in system–

You can view other videos on that too for reference

Hope this helps you

Thanks

[Pikachu_KH]

@Srini84

It did not help me. I tried the way said and I tried the ways which like you said. But it did not helps me

[Shikhar_Tandon]

Hi @Pikachu_KH,
just try putting a Not before your value in the if condition

ExtractDataTable.Rows(0).Item(“ColumnName”) = Not YourValue

like this.

Thanks,
Shikhar

[Pikachu_KH]

@Shikhar_Tandon

It did not work either. Is there possible the way that I follow is not true? I’ll leave my way to do is in the attachment.