Hi, I am trying to combine many csv files together using OpenRefine. I have all the csv files formatting uniformly but the month columns are not behaving as such. I have the parsing parameters set to columns separated by commas, Use character to enclose cells containing column separators, and to ignore the first 14 lines and parse next 1 line as header. I load them in but all the months are not lining up. I double checked the files and the column headers are all the same. Any help? I have a sample of files available here ccforopenrefindhelpdesk - Google Drive
I see it’s the formatting on the date column header on the individual cvs files. I will update each file and reload into OpenRefine. If there’s an easier way than editing each cvs, please let me know.
In OpenRefine you can also use column joining to combine the unaligned date columns into one.
Thank you so much. I did find this eventually, after I redid some headers. Thank you for taking the time to reply. I am new to OpenRefine!