Oh yes, I did read the post and try it out. So the attempt looked something like this:
JDBC Input
-- Filters
-- Aggregate filter to consolidate the records
-- jdbc streaming to add a new nested object array (history) from a different sql
-- split filter on history array
-- xml filter to transform the field1C to add a new element field1cReplacement
-- Aggregate filter (again)
It did not work for me earlier today. I guess i did not configure that properly. I will attempt this again tomorrow morning and update here.
thanks !!!