Hi,
Is there a way to specify how to link data between two incoming sources using a combine. I have two simple record sets. Five coming in port 1 and five coming in port 2. Each one matches only one record on the linked field. Is there any way to define that master / slave relationship like in other joiners? I see in the documentation that you join "based on tuples" but am not really sure what that means. Port1.LinkField = Port2.LinkField.
I can get done what I need to with other joiners just trying to understand combine better and if it's useful in other ways. Maybe like linking on multiple fields which is harder using other joins or multiple relationships instead of just one relationship like in the relationship join. All I can get it to do currently is randomly mix the data when it's combined. I can't enforce any linked/relationship fields.
thanks!
Is there a way to specify how to link data between two incoming sources using a combine. I have two simple record sets. Five coming in port 1 and five coming in port 2. Each one matches only one record on the linked field. Is there any way to define that master / slave relationship like in other joiners? I see in the documentation that you join "based on tuples" but am not really sure what that means. Port1.LinkField = Port2.LinkField.
I can get done what I need to with other joiners just trying to understand combine better and if it's useful in other ways. Maybe like linking on multiple fields which is harder using other joins or multiple relationships instead of just one relationship like in the relationship join. All I can get it to do currently is randomly mix the data when it's combined. I can't enforce any linked/relationship fields.
thanks!
-
Hi pintail
The Combine component does not utilize a 'Join key' property for joining data, instead the data is joined based on the order in which it arrives on the input, e.g. 1st with 1st, 2nd with 2nd, etc. Then these records are combined based on the provided transformation. Combine is most useful, when you need to do some basic joins without the need of using join key. Linking multiple fields would be probably much harder than in joiners with join key property, if not impossible.
If there is anything else we can help you with, please don't hesitate to contact us.
Best regards
Please sign in to leave a comment.
Comments 1