3 Replies Latest reply: Feb 7, 2012 6:23 AM by chris goudy RSS

    Load Inline

    chris goudy

      I'm trying to change BranchNo's to BranchNames in the Edit Script, but it keeps loading the numbers instead of the name

       

      Any help with something I'm doing wrong or missing??

       

       

      LOAD * INLINE [

          BranchNo, BranchName, F3

          0000, Head Office,

          0001, Tyger Valley

          0002, Klinikem

          0003, Palm Grove,

          0004, Cape Gate

          0007, Oudehof

          0008, Sanlamhof

          0006, Big Bay

      ];

        • Load Inline
          Kaushik Solanki

          Hi,

           

               I didnt got what you are trying to change. Can you explain in detail.

           

          Regards,

          Kaushik Solanki

          • Load Inline

            Hello Chris,

             

            The first line of your inline load indicates the column names you want to assign. The * in your load statement will be returning all the headings you have listed.

             

            You have 2 options to achieve what I undertsand is your requirement.

             

            1. LOAD * INLINE [ BranchName , BranchNameOld , F3

                

            0000, Head Office,

                0001, Tyger Valley

                0002, Klinikem

                0003, Palm Grove,

                0004, Cape Gate

                0007, Oudehof

                0008, Sanlamhof

                0006, Big Bay

            ];

             

             

            2.

            LOAD BranchNo AS BranchName , BranchName AS BranchNameOld , F3  INLINE [

                BranchNo, BranchName, F3

                0000, Head Office,

                0001, Tyger Valley

                0002, Klinikem

                0003, Palm Grove,

                0004, Cape Gate

                0007, Oudehof

                0008, Sanlamhof

                0006, Big Bay

            ];

             

            Hope that helps.