7 Replies Latest reply: Oct 11, 2017 10:55 AM by Pablo Nieto RSS

    Can I use a mapping table created inside a subroutine outside the subroutine?

    Pablo Nieto

      See the example below:

       

      Sub Mappings

           Codesmap:

           Mapping LOAD * Inline [

           Code, Description

           01, Code 01

           02, Code 02

           03, Code 03

           ];

      End Sub

       

      Call Mappings;

       

      Table1:

      Load

           Field1,

           Applymap('Codesmap',Field1) as CodeDescription,

           Field2,

           Field3

      FROM

      [Stuff.xlsx]

      (ooxml, embedded labels, table is StuffData);