Overview
Etlworks can generate a name for an empty name column.
Example
A column in the source dataset doesn't have a name (has a blank name):
Process
Etlworks handles it by automatically generating a name for the empty name column. The new name is generated as column + column index
. For example column2
.
If it is truly an empty column (no name and no data): you can easily exclude it in the Mapping or by using SQL, like the statements below:
select "Item Code", "Item Description", Group, "Qty On Hand"
If a column has no name but does have data: use a new auto-generated name, such as column2
.
Comments
0 comments
Please sign in to leave a comment.