I have a table A like:
123and a table B like:
111222333
I would like to run a process on each row at a time in table A e.g. join to another table B that matches then run a process on the match, write some features, then proceed to the next record in table A i.e.2 and run the same processes on matches in table B i.e. 2 and so on..
I don't know how to do this in FME without writing a cursor or loop in a script. Hope it makes sense.
Hi @tfsrichard, if the requirement is to merge features from the table A to the table B using the attribute (1, 2, 3, ...) as a join key, consider using the FeatureMerger or the FeatureJoiner transformer.
Hi @tfsrichard, if the requirement is to merge features from the table A to the table B using the attribute (1, 2, 3, ...) as a join key, consider using the FeatureMerger or the FeatureJoiner transformer.
Hi takashi, the requirement is more like I want to iterate through table 1 one feature (number) at a time then find the match numbers in table 2 run processing the move to the next feature (number) in table A and do the same for each record in table A
Sounds like you want the FeatureMerger with the generate list-option
See the docs: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/featuremerger.htm