CSV
Dataedo 9.1 added support for CSV files. Dataedo scans CSV file and creates a new object (Structure) with a list of columns, each containing:
- Column name - Dataedo assumes the first row contains column names. If that is not the case, 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 field types and save with Save button.
