This content has been marked as final. Show 1 reply
I'd use instead a mapping load and a MapSubString() in the field
OldNewValueMap: MAPPING LOAD * INLINE [ Contractor, Contractors contractor, Contractors Contractor , Contractors SI, SIPartner SI , SIPartner SI Partner, SIPartner ?, Other FTC, Other ]; Change: LOAD *, MapSubString('OldNewValueMap', [Contractor / Permanent]) AS [Contractor / Permanent_New] INLINE [ Contractor / Permanent Contractor Different Value contractor SI Partner ? FTC ftc ];
Hope that helps.