Seems like Edit Schema is just editing the temporary schema (WKF). Just like editing schema source in configuration, but instead it's on the fly. So, an expression field can be added to the WKF to be used further downstream. Since it is just an expression to the temp schema, it doesn't create a data...

Hi Jon,These are really thoughtful answer. Thank you for that.I ended up using Edit Schema activity to create the expression. Btw, how do you find those undocumented js functions? I tried to look them up under Configuration > JavaScript codes, but they are not there.Thanks,- Alwi

I have a schema with a string field of length 2100.In enrichment, an expression field is added which does a substring of that field such as this: Substring(@recommendation, 101, Length(@recommendation)-100)  This is the error I get:03/03/2020 12:01:29 PM enrich PostgreSQL error: ERROR: value too lon...