Exporting Records - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
First publish date
2007
Last updated
2024-03-04
Published on
2024-03-04T22:52:13.486265

You can export data for all records from a dataflow to a comma separated value (CSV) file. You can then import the data into other applications such as Microsoft Excel.

This procedure saves data for all of the records from a dataflow to a CSV file. The first (or header) row in the CSV file lists the field names. Subsequent rows list the corresponding values for each record. Field names and data values are enclosed between double quotation marks (").
  1. In Data Stewardship Portal, open records for the dataflow that you want to export on the Data Stewardship Portal Editor page.
    To do this, click Editor on the Data Stewardship Portal toolbar, then in the Dataflow name box in the sidebar select the name of the dataflow.
  2. Make sure that the records are displayed in Tabular view.
    If necessary, click the Tabular view button on the Editor toolbar.
  3. On the Editor toolbar, click the Export all records button .
  4. If prompted, choose to save the file.
All the records created by the dataflow are exported to the browser default download folder. The exported file name is DataflowName_StageLabel.csv, with the dataflow name and stage label of the dataflow that created the records. If records created by a dataflow are exported repeatedly, the files are numbered incrementally in parentheses after the dataflow name as DataflowName_StageLabel(number).csv.
After you complete this procedure, you can open the file and edit records in another application, such as Microsoft Excel or a text editor. After you complete the changes, you can load the data back into a workflow in Enterprise Designer.