I need your help. Please have a look into below question.
I have a csv file with 6 columns. Out of which one column named “Date” is having multiple rows with dates in mm/dd/yyyy(7/1/2021) format(I am not sure if format will change in future). I am reading the csv and storing it in a datatable. so now the date column format has changed to yyyy/mm/dd after using “read csv” activity. And the column type is string.
Requirement : I have to split the csv file into multiple files as per Month. for example if there are 3 months data in that column, then i need to split the whole file into 3 files accordingly. Then i need to upload those files somewhere.
I was able to get the solution but still need some inputs from you all for the best solution.