I have a csv file with data ( CID,“City”,“Date”,“Day”,“DealerAgentId”, ) and i want to divide it into different columns using delimiter as comma.
When i did in excel it was working fine. but when i did with read csv and in property its not working as expected.
Can someone help me on this. I will upload the input csv file and also final output how i wanted.
Input and output csv : input and output csv.zip (791.1 KB)