Hi
i am relatively new FME user. i am trying to complete a task but any path i pick i crash on a wall. I have an SDE drive with feature classes and table. Each feature class record has a primary key which is linked to my tables through a foreign key field. I need to know who many times a primary key value is found in my tables, create a new feature class and give in separate fields named (1st visit, second visit etc) some information about the table the record was found.
What is the best path and how to get there.