Importing Data from a Text File
In the Factory, you can import directly data from a text file, defining the basic parsing options. You can do it by either:
Dragging the text file directly onto the Stage, automatically creating an Import from Text File task.
Dragging an Import from Text File task onto the Stage: this operation allows you to make a more precise import operation, as you can:
Import a single file, specifying the parsing and import options for the specific file;
Import multiple files together, concatenating them into a single table. This means that all files imported together must have the same structure.
A preview of the imported table(s) is always displayed.
You must have created a flow;
In case you are importing multiple files, they need to have the same structure.
Drag an Import from Text File task onto the Stage.
Double click the task and open the task menu.
Choose from the drop down list if you want to import the file from your computer (Local) or from a remote connection.
If you are importing from a Remote Filesystem, choose it from the list and then click on the pencil button to set the connection information required (only if you are using a Custom source). The tables are loaded in the Files tab.
If you are using a Local Filesystem, drag the Excel files onto the file area or click on the Select File button and choose the path.
Click on the Concatenation Type’s drop-down arrow to choose Inner or Outer concatenation.
Inner concatenation final table includes only attributes that exist in both tables.
Outer concatenation final table includes all the attributes, filling in any missing values if necessary.
Click on the Match Column by drop-down arrow and choose if you want to match them by their Name or by their Position.
Click on the Text Configuration tab and set the Parsing options and Import options, as shown in the table below.
Save and compute the task.
Parsing and Import options
Here you can set: