I have a data table consist of 4k rows of data and I need to trim a trailing space in a particular column called JO No.
as you can see above there is a spacing behind the value.
This is what I have come up with to the trim the spaces in the column but it does not seem work properly. Could anybody point out what I should do to fix this workflow?
YPD Variance map testing.zip (149.6 KB) here is my workflow