We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

CSV/Delimited Input: Field already exists in metadata

Comments

2 comments

  • Avatar
    Stéphane O

    Hi Reena,

    2 columns with the same name can definitively not be imported

    I had to face this situation and renamed the header with an Unix text editor. Depending of the file size, you may be able to rename it with a Windows-based tool such as notepad++

     

    Any idea to proceed with duplicate columns names directly with Data3sixty is more than welcome 

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    If the files have a consistent metadata specification - i.e. all files have the same field names and the fields are in the same order across all files then you can configure the 'Fieldnames' property with a comma-separated list of the field names to be used as the output field names. The input headers are then ignored by the node.

    If the metadata is different across the files then each group of files with the same metadata specification would need to be imported separately (e.g. by placing them in different directories or naming the files so that a different pattern can be used to select the group of files in the Directory List node) - you can then, if required, concatenate the data using a Cat node that is configured to generate the union of the input fields.

    0
    Comment actions Permalink

Please sign in to leave a comment.