What is the syntax for same and common attribute name for two datasets (parent and child tables) in Tester? If i give same field name for both Left and same values, iam getting merged all data. But i need only matched records. $(SourceDataset_CSV).@Value(#EMPNo)?? How can i access the same attribute name when we have many datasets?
Solved
What is the syntax for same and common attribute name for two datasets (parent and child tables) in TestFilter?
+4- Contributor
Best answer by nataraju
Hi @itay
iam reading three oracle tables, having common field name and its same. i tried table1.id=table2.id, but some how not working.
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.
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.
+19- Supporter
Hi @natrakju,
You can prefix the attribute name before using the tester on the different features (tables).
Depending on the input format either the fme_basename or fme_feature_type will hold the feature (table)name.
This is probably also possible within the test filter using feature functions.
+4- Contributor
- Best Answer
Hi @itay
iam reading three oracle tables, having common field name and its same. i tried table1.id=table2.id, but some how not working.
Hi @natrakju, sounds like you are trying to join two tables using the id attribute as join key. If so, the FeatureMerger transformer might help you.
+19- Supporter
Hi @itay
iam reading three oracle tables, having common field name and its same. i tried table1.id=table2.id, but some how not working.
I think that in our case you are better off by reading one table and using the joiner to match to the records of tables 2 and 3.
This way the db carries the heavy lifting of the join and you dont need to read all the features into the workspace.
+59- Safer
As Takashi says, It sounds like you are trying to compare two tables. Either you must merge them as he suggests, or use a Tester-type transformer that has multiple input ports.
For example, the ChangeDetector will be able to test for matches of an attribute in two different tables. The FeatureMerger is another good method, even if you don't want to merge the data!