Etlworks can generate a name for an empty name column.
A column in the source dataset doesn't have a name (has a blank name):
Etlworks handles it by automatically generating a name for the empty name column. The new name is generated as
column + column index. For example
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