I have a CSV file with duplicate column names. I have to fix this in the CSV file before being able to work with the file in Dataverse. Dataverse Gives me an error message and 0 rows in the output pin.
For Excel import there is a Error Behaviour setting to autoname columns (creating column names like description and description1 for the duplicate column name). This is great and needs to be in place for CSV files as well.
Also in my CSV there are column names with ":" as not allowed characters for metadata which is then rejected by Dataverse with no possibility to fix this in Dataverse but manually in the CSV file. This could be autofixed in Dataverse by e.g. removing or replacing these special characters.
Currently using Dataverse 3.1.4
Please sign in to leave a comment.