topic Link Table in QlikView

Link Table

Thu, 28 Apr 2016 15:24:10 GMT

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 — Thu, 28 Apr 2016 15:28:19 GMT

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