Hello, Did you try to use the Expression node? The left, len and trim function exist, which could be reused pretty much identically.
What is the type of ColumnA in input? Does it need to be changed to a varchar?
If not, you can use something like: `ColumnA` = LEFT(TRIM(`ColumnA`),LEN(`ColumnB`))
Otherwise, you might want to add a tostring function: `ColumnA` = LEFT(TRIM(tostring(`ColumnA`)),LEN(`ColumnB`))
For the second line, only the substring function doesn't exist, it can be replaced by a combination of LEFT and RIGHT.
Hope this helps. If you need a more detailed help, do not hesitate to reach out to support.
Thanks,
Audrey
... View more