Spectre Flow Alias Process Object

The Spectre Flow Alias Process object allows you to rename columns, choose which columns to keep in your data flow, and choose which columns to remove from your data flow.

The Alias Process object has three sections in the properties panel where you set attributes.

Spectre Flow Alias Node Properties

You set attributes for the Alias Process object in the Closedobject attributes section.

Attribute Description
Remove Other Columns If true, any columns where the Keep attribute is false are removed. For information about the flow script tag, see remove-other-columns.
Prefix Sets a string to add to the beginning of the names of all columns from this input. For information about the flow script tag, see prefix.

Each object has an area where you can enter comments. It is DI best practice to enter a note for every object in a Spectre Flow script.

Every Spectre Flow node comment area is Markdown-enabled. For more information, see Workbench Markdown Editor.

The Alias Process object Closedcolumn grid section displays information about the columns from the input files.

Spectre Flow Alias Node Column Grid

Attribute Description
Name Displays the name of each input column. This attribute is read-only.
Alias Defines an alternate name for one or more input columns. Spaces before or after an alias column name are ignored. Spaces within an alias column name are acceptable.
Type Displays the type of each input column. This attribute is read-only.
Keep

Manages which columns are kept in the output data flow. If no columns have a Keep check mark, all columns are kept in the output data flow, except for any explicitly marked Drop.

Select the Keep check box for columns you want to explicitly keep in the output data flow. A number is automatically added in the Keep Order column when you select its Keep check box. After marking any column with a Keep check mark, only those marked Keep are kept in the output data flow.

NOTE: After any Keep check boxes are checked, do not use the Drop check boxes, because clicking a Drop check box sets all Keep check boxes to unchecked.
Remove

Manages which columns are removed from the output data flow. Select the Remove check box for columns you want to explicitly suppress from the output data flow.

NOTE: Use the Remove check boxes only when no Keep check boxes are checked.
Keep Order Manages the order of the columns in the output data flow. By default, columns that are passed to the next object in the data flow are displayed in the order in which they appear in the Name column. You can change this order by typing a number in the Keep Order column. When you assign a Keep Order number, the Keep column is checked automatically. The Keep Order numbers might reorder to accommodate any changes you make.
Props Opens the Edit [Column] properties window. Only available for columns where Keep is true.
Copy Specifies the name of a new column that is created as a copy of the current column.
Props Opens the Edit [Copy Column] properties window. Only available for columns where Copy has a value.