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