2 Replies Latest reply: Apr 28, 2016 11:29 AM by Ruben Marin RSS

    Link Table

    Channing Dionisopoulos

      Hi all,

       

      I am trying to make a link table.  In order to do so, I am making a KeyField for my three tables.

       

      RFX_Transactions:

      LOAD [RFx ID]&'|'&[Supplier ID]&'|'&%DD AS %KeyField,

           [RFx ID],

           [RFx Title],

           [Organizational Unit],

           [Planned Open Date] AS %DD,

           [RFx Response Due Date],

           Proposal,

           [Supplier ID],

           [Supplier Name] AS [Supplier Name RFX],

           [Response Status],

           Material,

      etc......................

       

      Above is the beginning of my first table.  When I run this, it cannot find the %DD field, probably because I renamed [Planned Open Date] to %DD under it.  Does anyone have a suggestion of how to do this?  I don't want the linked field to be called [Planned Open Date] because I am linking %DD to the calendar.

       

      Thanks!

       

      Channing

        • Re: Link Table
          Sunny Talwar

          You are right, Try this (NOTE: you can still rename it to anything you want, but you need to use the original field name while still creating new fields in the same load)

           

          RFX_Transactions:

          LOAD [RFx ID]&'|'&[Supplier ID]&'|'&[Planned Open Date] AS %KeyField,

               [RFx ID],

               [RFx Title],

               [Organizational Unit],

               [Planned Open Date] AS %DD,

               [RFx Response Due Date],

               Proposal,

               [Supplier ID],

               [Supplier Name] AS [Supplier Name RFX],

               [Response Status],

               Material,

          etc......................

          • Re: Link Table
            Ruben Marin

            Hi Channing, to read the field you must use the name it has in the source.

             

            If the field is named [Planned Open Date], the KeyField should be:

            RFX_Transactions:

            LOAD [RFx ID]&'|'&[Supplier ID]&'|'&[Planned Open Date] AS %KeyField,

                 [RFx ID],

                 [RFx Title],

                 [Organizational Unit],

                 [Planned Open Date] AS %DD,

                 [RFx Response Due Date],

                 Proposal,

                 [Supplier ID],

                 [Supplier Name] AS [Supplier Name RFX],

            ...