IS the Excel file your loading from have the column headers as col 1, col 2 etc with the values under them? If so you can skip the 1st line like this,
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
you can use the rename function with a mapping load:
Mapping Load OldFieldName, NewFieldName From FieldNames ;
Rename Fields using FieldNameMap;
We can not write direct Query based on SalesHeader column name ??
Suppose I am loading SalesData table there Can it be possible to Assign column name as SalesHeader column values ??
[A], // Here I want assign column name will be SalesHeader Column value
(ooxml, no labels, table is Sheet1);
Is it possible??