Hi,
Think I put this in the wrong location, moving from Authoring to Desktop.
I'm having a difficult time getting global variables to both set and retrieve. I've got a table that is updated with deltas from another table. I need to get the last used number of a unique id in the updated table so that I can create the next sequential number and append the unique id to the one being appended. I'm already using one set of variables (both setter and retriever) for determining when the last modification of the script log file was done in order to grab only the latest ones (this is ultimately going to be a triggered script in FME Server) - this part is working well and I'm getting the latest additions to the table for append.
The part giving me difficulties: Need to read the appendee table to get the max number of an id, ABC2021-00##; where 00## is the max number assigned (can't use count since there could be some deleted items - purposely tested this). Getting max using StatisticsCalculator, currently number is 10. My next number would be 11 via an ExpressionEvaluator. This works fine on this part of the script. Set a global variable to the result. In another section of the script just before I write the new feature, I need to get this result from the global variable in order to create the new unique id number to be written with the new feature.
I'm thinking that this will work well for one new record, but not sure that it will work for several new rows to be appended to the data.
Thanks,
Jazmateta