How to deal with multiple data type conversions in large ETL-flows


In complex flows in EasyMorph e.g. a very wide dataset that we have to put in a database at some point or loads of transformations to be performed, I sometimes struggle managing the data types.
Sometimes it gets realy confusing because for some operation (e.g. applying text functions) we have to first convert to text, then perform the function and perhaps cast it back to number, etc (e.g. extract number from text and convert to number). So it is not possible to always set the convert to data type action always as a first action in the flow but it occurs often at different points.

Therefore I was thinking that it would be nice if there was some sort of magic clean-up function that could merge alle convert dat type actions intelligently in one action as much as possible without breaking the flow so as to minimize the number of points where these actions occur.

Any suggestions on that or best practice recommendations?

Thanks !

I’m not sure I understand the question. Can you provide an example?