How do i Encounter this Assign: The source contains no DataRows Error

[kishan.savaliya]

Hello

I am Comparing The Two Sheet. if Both Sheet Contains Same Data then it will throws error…if One sheet have More or Less Data then it will Working Properly…

I have attached Expression.

I have tried Try catch (Error handling) But it is not working Still it is Throwing the Same Error…

I want to Skip this Activity if data is Same in both Sheet…

[ppr (Peter)]

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

But we would also recommend to check the LINQ on the options to reformulate it e.g.

(From d1 in LastYearPL.AsEnumerable
Where Not CurrentYearPL.AsEnumerable.Any(Function (d2) d2("Account").toString.Trim.Equals(d1("Account").toString.Trim))
Select r=d1).CopyToDataTable

[kishan.savaliya]

@ppr Still Error…Source Contains No Datarows, If the Sheets Data is Same, It works if there is Less or More Data in both Sheet

[Yoichi]

Hi,

Did you try it on debug mode? If so, can you try to turn on “Continue on Exception” in Ribbon menu? OR just Run (not debug)?

In debug mode ,it stops if exception occurs and the above settings is off.

Regards,

[kishan.savaliya]

@Yoichi I tried this one but Workflows Rest operation Doesn’t Worked…

[Yoichi]

Hi,

Can you elaborate? If exception occurs in Try block, Workflow flows into Catch block. Is this your expectation?

Regards,

[kishan.savaliya]

Yeah @Yoichi I Forgot to add Activity in Try Catch Block…It working Absolutely Fine…Thanks a Lot