Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  CSV Import with autoname columns

    Posted 08-31-2017 09:41

    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



  • 2.  RE: CSV Import with autoname columns

    Posted 09-05-2017 23:32

    Similar problem by the way with JSON node. We have JSON response from webservice which uses ":" in some JSON object names, and JSON node throws an error not being able to handle these names. The JSON node should autorename these columns and replace or escape the ":" automatically.