Hello there!
Great question! Would you want to do this all within the transformer?
If not, you can do something like this as an additional transformer.
If this doesn't work for you, do you think you could share a screenshot of your bottom panel with this transformer that is erroring out?