I'm trying to join a Shapefile to another table, but it fails.
The joining attribute(encoded: utf-8) has value "41400562015" but during the prozessing it becomes "41400562015????????????????????????"
I tried to change the attributetype of both fields into different types, including integer or varchar (12) - but the resulting string is still longer than 12 digits?... I also tried to calculate the string (left 12) into a new attribut or to use the trim-funktion. Nothing works?
not to be misleading: the original connection attribute on both sides is a textstring like "BT-4209-0001-2018". No blancs.
But the joining failed and i detected something like
"BT-4209-0001-2018 ___________ " with empty spaces at the end
Because the connection with strings did not work, i changed it into numbers, so joining in FeatureMerger or InlineJoiner should be .
(I
have done the same connections thousands of times, these
difficulties with shapes are only occurring sometimes and are quite new (FME2017)