Error in reading column name of a csv file

Learn Academy Feedback
21

Hi @supu123,

I guess it would be best if you can share your solution with me, So that I can do some debugging and see where it is going wrong and why it is getting assigned as null. Make sure to include the excel/ csv file you are trying to load as well

if sharing the solution is okay with you :slight_smile:

22

Hi @Lahiru.Fernando
Below is the files attacheduipath.zip (9.4 KB)

23

Hi @supu123,

Looks like the problem is not with your workflow, but with your file. I opened the csv file, and went to the save as option, by default it is selecting ‘unicode text’ format. Ideally, when I go to save as option, it should show the currently saved format. So, I think the problem is with the excel. I saved the same file with the csv format by going to save as option. Then I pointed to that file and ran the workflow and it worked fine…

Wonder how that format changed, but that seems to be the issue :slight_smile:

24

Hi @Lahiru.Fernando
Yes,the problem is with excel sheet itself it seems.

Thanks and Regards
Supriya

2 Likes