in a normal database environment I would use an innerjoin. What tool or combination of tools can I use in FME to achieve this"
Question
I would like to know how to combine 3 CSV into one CSV based on a common attribiute.
- Contributor
+32- Influencer
I would first send all three source CSVs to an Aggregator using Group Processing with Group By set to ID. You will also want to set the Accumulation Mode to Merge Incoming Attributes. This will create a single feature for each of the IDs containing the attributes from all the incoming tables. From there you can use an ExpressionEvaluator to perform your operations in the 'Magic Tool', and output to your CSV writer.
- Contributor
Super thanks @dustin !! your solution worked perfect for me.
In my Magic tool, I also tried out "AttributeManager" and that seems to also do the work of the "ExpressionEvaluator" is there any pro - con in using either of the two?
+32- Influencer
Super thanks @dustin !! your solution worked perfect for me.
In my Magic tool, I also tried out "AttributeManager" and that seems to also do the work of the "ExpressionEvaluator" is there any pro - con in using either of the two?
No, they can be used interchangeably to get the same result. I prefer the AttributeManager for things this, actually. But I usually recommend the other transformers on the forum just for the ease of explanation.
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.