Trusted Contributor.. Hope Trusted Contributor..
Trusted Contributor..
370 views

How to relate departments and employees

Hi there,

How to relate departments and employees according to a common attribute using the connect-it automatic download of data if they are stored in the same table in amEmpDept?

0 Likes
2 Replies
Acclaimed Contributor.. Mark Cullen_1 Acclaimed Contributor..
Acclaimed Contributor..

Re: How to relate departments and employees

You may need to supply screenshots and/or explain more, however, treat the root table in mapping as the employee and use the 'Department (Parent)' link branch for said department.  Setting the reconciliation key(s) (ie. red keys) for both will give you what you want.  These reconciliation keys do not have to be the same for each, however, they must uniquely identify a table record respectively.

0 Likes
Highlighted
Acclaimed Contributor.. Mark Cullen_1 Acclaimed Contributor..
Acclaimed Contributor..

Re: How to relate departments and employees

When I wrote you may need to explain more, it is because I do not understand "...using the connect-it automatic download of data...".  Does this relate with out of the box scenarios?

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.