This content has been marked as final. Show 5 replies
It seems to me an example of one of the uses for ApplyMap() function, if I got you right
StoreCodeNameMap: // one map will do for all tables MAPPING LOAD Code, Name FROM File.xls; AccountExtract: LOAD *, ApplyMap('StoreCodeNameMap', Code, 'Name not found') AS Extract_Store_Name // "Name not found" literal above will be returned should no code match the mapping table // Making easier to identify where the problem is FROM Extracts.Source; Transactions: LOAD *, ApplyMap('StoreCodeNameMap', Code, 'Name not found') AS Transactions_Store_Name FROM Transactions.Source;
Hope that helps.