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?
You can check the condition as
ExtractDataTable.Rows(0).Item("ColumnName") = YourValue
Check below for your reference too
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
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
just try putting a Not before your value in the if condition
ExtractDataTable.Rows(0).Item(“ColumnName”) = Not YourValue
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.