Link Table

[#1]

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

[sunny_talwar · Accepted solution]

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......................

[rubenmarin]

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],

...