Question

compare attributes of two different tables

Forum|Forum|12 years ago
November 21, 2013
2 replies
277 views

+7

vki
Contributor

I have two tables that are related through two attributes (Attribute A of table 1 and Attribute B of table 2). Now I would like set a new ID-Attribute (primary key) in table 1 and use this ID as the foreign key in table 2.

That means that I have to compare the attributes of the two tables and if attribute A of table 1 equals attribute B of table 2 then I write the ID-attribute of table 1 as FK to table 2.

I looked through the transformers but I couldn't find one where I was able two compare attributes of two different tables. But there sure is one...?!

Thanks in advance

Vera

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.