Using Input Files

You can add existing files to iWay DQC Manager for use as input data for a Plan. For example, you can add files by dragging and dropping them from the file system to the desired project in the DQC Explorer, or by copying them from the destination folder to the desired project folder inside the workspace folder in the file system.

To use an input file in a Plan, you must first assign it metadata describing the format of the data. When a data file (for example, .txt or .csv file) is opened for the first time, the Metadata Editor is launched. It presents options on how to read the file, such as the type of delimiter used, the data types of each column, and whether the file contains header rows.

You can preview the resulting data in the lower panel of the editor to assess the results of the metadata settings. Clicking OK in the Metadata Editor opens the data file for viewing. You can edit the file metadata later by right-clicking the file and clicking Edit Metadata.

To use input files inside a Plan, add one of the input steps to the canvas (for example, Text File Reader or Excel File Reader), and type the input file name in the File Name property. For more information on the available steps in iWay DQC Manager, refer to the documentation for each step. Alternatively, you can drag text files from the DQC Explorer directly onto the canvas, where a Text File Reader is generated after the metadata is created.


iWay Software