Hello, I am looking for the equivalent to the "Append Fields" tool in Alteryx, where many rows from one table are replicated for each row of another table. For example:
Table 1:
Table 2:
Target Table:
I've searched and experimented, but can't seem to sort it out in FME. Any advice?
Thanks!
Best answer by daveatsafe
Hi @netsunnix,
You can use a FeatureJoiner with the Join Mode set to Full to get the results you want. You will need a common attribute value on all the features to join on, but this is easily created with an AttributeCreator. In this case, I created the attribute _join and set the value to 1.
The results:
+19Hi @netsunnix,
You can use a FeatureJoiner with the Join Mode set to Full to get the results you want. You will need a common attribute value on all the features to join on, but this is easily created with an AttributeCreator. In this case, I created the attribute _join and set the value to 1.
The results:
Hi @netsunnix,
You can use a FeatureJoiner with the Join Mode set to Full to get the results you want. You will need a common attribute value on all the features to join on, but this is easily created with an AttributeCreator. In this case, I created the attribute _join and set the value to 1.
The results:
Fantastic, that worked! Thanks so much!
