good day, please help me rename field in load editor so that i can use that as a connection in mapping load without having to change column name from external source.
unqualify *;
LOAD
[barcode] as [ALU],
[name]
FROM [lib://Desktop/Book11111.xlsx]
(ooxml, embedded labels, table is Sheet1);
[name]:
Mapping LOAD
[ALU],
[name]
FROM [lib://Desktop/Book11111.xlsx]
(ooxml, embedded labels, table is Sheet1);
[Sheet2]:
LOAD
[ALU],
ApplyMap('name',[ALU]) as [name]
FROM [lib://Desktop/Book11111.xlsx]
(ooxml, embedded labels, table is Sheet2);
