
Contributor III
2020-05-21
10:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
rename field name to be used as map_name
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);
- Tags:
- fil
463 Views
1 Reply

Partner - Creator
2020-05-22
01:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you please provide what your source tables contain and what you want the result table to contain.
434 Views
