Also you need to use the actual field name instead of the new field name here:
LOAD Customer as SellToCustomer,
Channel as A,
If(Industry <> '.' , ApplyMap('MAP_CAT_CODE', [Industry Code], 'IA BLANK'), ApplyMap('MAP_CHANNEL', Channel, 'IA BLANK' )) as JDE_SECTOR,
SectorDesc as JDE_SECTOR_DESCRIPTION
[O:\Rapportering\QV\Sector Change\JDE SECTOR - Daily feed.xlsx]
(ooxml, embedded labels, table is Sheet1);
Thank you both..
The missing mapping, where because I "cleaned" the code with all the company names etc. and i removed to much.
It's was as you both suggested the Reference in the Applymap I had misunderstood. I though i should you the name from the mapping column. And when i used the field names from the actual load It worked perfect.
PS. What does it take to be able to post in real time? Really annoying you sometimes have to wait several hours before it's approved.