Hi,
I use a calculated column by Truncate Text to link to an another table.
Although the values seem to be equal, the link with an another column (type Text) does not work. I suspect a format problem.
How to solve the problem ?
Thanks.
Can I see a screen shot of the two columns that you are trying to match, please?
Yes.
Column Rf (type Truncate Text) of table Taille
Column Référence (type Text) of table Segmentation
Okay. I believe that your issue is that the truncated string will have ... on the end of it, which is why you won’t get a match. If you widen that Rf column a bit, you should see that.
I’d suggest using the Text Slice column instead. It’s more suited to this. To get the first 7 characters you’d Start at 0, and give it a length of 7.
1 Like
Solved with Text Slice.
Thanks.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.