Hi, with uncertain input (Excel spreadsheets) full of junk of variable types. I suggest allowing the Attribute Trimmer , when trim to nothing is set , add the option to setting the result to null. This would allow easy selection of attributes, trimming to zero length and then setting t o null thus avoiding wasting time finding (or not) a regex expression from the internet that will do the above in the null attribute mapper.It could also be implemented in the null attribute mapper.
Migration Note: Idea originally posted on 2024-02-04
Be the first to reply!
