Error in reading column name of a csv file

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:

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

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:

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

Thanks and Regards