I am using FME Form 2025 and the ChangeDetector to identify differences in records from two tables with the same schema. I have ChangedOutput create List(s) named “Changes”. What Transformer do I need to connect to the Inserted and Deleted Ports to get a look at the Lists?
If you just want to view the lists, you can click on the cache and view the list in the Feature Information Window (now called Record Information in 2025.1).
Thank you for the answer. I guess I need to clarify my post. I would like to export the list into a CSV.
How can I expose the List Attribute created in ChangeDetector? once exposed I can one of the List Transformers after the ChangeDetector to help me get what I need.
I found the answer. The List can only be exposed for UPDATED in the ChangeDetector using ListExploder. It appears that INSERTED and DELETED the List cannot be exposed using ListExploder.
Hi
Are you comfortable sharing a small sample workspace or more images? I’m not sure I’m experiencing what you’re describing, where the INSERTED or DELETED lists are unexposed and cannot be manipulated by typical list transformers namely the ListExploder transformer.
I closed the ticket since Sara provided the answer I needed.
How would a list look like from the inserted and updated port?
As far as I understand the ChangeDetector does not create any lists for the inserted and deleted port as there are no “changes” made in the data. In other words, it can’t show you how it looked before and how it looks now, that would just be a “before it was empty now there is data” or “before there was data now there is no data”. And in a list it would just be an empty value and then the new value and vice versa, I guess it doesn’t give a lot of information?
If you just want to have a summary you can maybe just add an attribute with the AttributeCreator after the corresponding port that states if the row was inserted or deleted?