CSV support

9th March, 2021
Applies to: Dataedo 9.x versions, Article available also for: 10.x (current)
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 10.x (current).

Dataedo 9.1 added support for CSV files. Dataedo scans CSV file and creates new object (Structure) with a list of columns, each containing:

  • Column name - Dataedo assumes first row contains colum names. If that is not then columns are named "Col_0", "Col_1",...
  • Data type - Dataedo looks at data and tries to cast it to one of the core data types (String, Int, Double, DateTime)

To add CSV file right click on any database or Structures folder, choose Add Object, then Add/Import Structure, then select either Paste Document if you want to paste file content or Import from File if you would like to read from a file, select file from the disk. This will scan the content and open Structure designer with a parsed structure. You can use this window to edit names, data types and filed types and save with Save button.

Guide: Adding files to the catalog

Found issue with this article? Comment below
There are no comments. Click here to write the first comment.