Errror Compare Two File

[Muhammad_Taufik_Akbar]

Hi guys I found an error i just wanna compare with 2 file different excel one csv with no row and one xl with how it compare the file, if there is a blank or not and the data was same or no

[sasi_poosarla (sasi p)]

hi,@Muhammad_Taufik_Akbar

try to use read csv activity to read csv file

[Muhammad_Taufik_Akbar]

hi it still not work The error was like Assign: The source contains no DataRows.

[Jon_Smith]

Where are you assigning a value to that variable?
Its indicating that it loaded no rows so something is going wrong there.

[Muhammad_Taufik_Akbar]

iam not sure bro can you teach me?

[Jon_Smith]

I’d need to see where you are assigning the variable bud.

Its hard to help unless you help us by providing information.

[Muhammad_Taufik_Akbar]

ShetDT1.AsEnumerable.Intersect(ShetDT2.AsEnumerable,System.Data.DataRowComparer.Default).CopyToDataTable this one bro

[Jon_Smith]

Thats where the error occurs, not where the variable is assigned, I need to know where you assign ‘ShetDT1’.

[Muhammad_Taufik_Akbar]

in this one bro

[Jon_Smith]

Nice, so thats some progress.

Use some break points and the locals window to confirm that variable has some rows loaded, then do the same for ShetDT2.

If both have rows loaded then it would suggest there are no matches between your two tables and the error is on the copytodatatable which cannot happen as there are no rows.

[Muhammad_Taufik_Akbar]

can you show me the example?

[Jon_Smith]

What do you want an example of?

[Muhammad_Taufik_Akbar]

Use some break points and the locals window to confirm that variable has some rows loaded, then do the same for ShetDT2.

If both have rows loaded then it would suggest there are no matches between your two tables and the error is on the copytodatatable which cannot happen as there are no rows.

this one bro, i dont really understand what is this how to do it its my first time doin this

[Jon_Smith]

Ok,

Here is some documentation and a video that explains debugging with an example
https://docs.uipath.com/studio/standalone/2023.4/user-guide/the-breakpoints-panel
https://docs.uipath.com/studio/standalone/2023.4/user-guide/about-debugging

Use of BreakPoints in UiPath Studio debugging | Breakpoints panel | Importance while debugging

[supermanPunch (Arpan)]

@Muhammad_Taufik_Akbar

still not work The error was like Assign: The source contains no DataRows.

Hi @Muhammad_Taufik_Akbar ,

For the Error received, we could handle it as mentioned in the below post :

[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…