I have an error on Read.csv file

error
How to resolve this error.
I am currently working on Assignmnet UiPath Advance

Hi @Ammaz_Ahmed

What’s the error that you are getting?

Read CSV: Could not find a part of the path ‘C:\Users\DELL\Documents\UiPath\Generate_Year_Report_Performer\Data\Temp\Report- RO254678-2022-\January.csv’.

This is an error i have got

@Ammaz_Ahmed

Check both file path and file name are correct or not.

Is the file name January or Report- RO254678-2022-January?

Hi @Ammaz_Ahmed ,
Can you share your error notification?
If
Not found file, you can check file in your PC then try again,
to get correct file path you can keep key ‘Shift’ and right click then select ‘Copy as path’


regards,

@Ammaz_Ahmed

looks like the file name is Report- RO254678-2022-January.csv

but you have an extra slash…correct the same

Hope this helps

cheers

This is our Actually Error , It download a file, But it throws an error on Read CSV Please any person help me

File Name not January. Its name was Report- Some thing like this

Hi @Ammaz_Ahmed

Please check whether the file is downloaded in Particular folder or not

Remove slash(\) before january because it takes slash(\) as path

@Ammaz_Ahmed

How are you costrcuting reportFilePath…please shwo that looks like soemthign is wrong over there

cheers

This is our File Path, Please check this , Is am i right

@Ammaz_Ahmed

Write this in assign activity to get the latest downloaded CSV file in that folder.(Make sure this is the downloaded files path)
latestFile = Directory.GetFiles("C:\Users\DELL\Documents\UiPath\Generate_Year_Report_Performer\Data\Temp\", "*.csv").OrderByDescending(Function(file) New FileInfo(file).LastWriteTime).FirstOrDefault()

Then pass the variable in read csv activity.

@Ammaz_Ahmed

After in_Year, remove the comma(,) and use plus(+) that should solve the issue

Happy Automation

cheers