# How to use a truncated column to link 2 tables?

**URL:** <https://community.glideapps.com/t/how-to-use-a-truncated-column-to-link-2-tables/63672>\
**Category:** Ask for Help\
**Created:** [July 8, 2023, 1:16pm UTC](https://community.glideapps.com/t/how-to-use-a-truncated-column-to-link-2-tables/63672 "2023-07-08T13:16:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![zephir](https://avatars.discourse-cdn.com/v4/letter/z/e95f7d/32.png) [@zephir](https://community.glideapps.com/u/zephir)\
**Post date:** [July 8, 2023, 1:16pm UTC](https://community.glideapps.com/t/how-to-use-a-truncated-column-to-link-2-tables/63672/1 "2023-07-08T13:16:07Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 8, 2023, 1:40pm UTC](https://community.glideapps.com/t/how-to-use-a-truncated-column-to-link-2-tables/63672/2 "2023-07-08T13:40:05Z")

</div>

Can I see a screen shot of the two columns that you are trying to match, please?

---

<div class="post-metadata">

**Author:** ![zephir](https://avatars.discourse-cdn.com/v4/letter/z/e95f7d/32.png) [@zephir](https://community.glideapps.com/u/zephir)\
**Post date:** [July 8, 2023, 3:23pm UTC](https://community.glideapps.com/t/how-to-use-a-truncated-column-to-link-2-tables/63672/3 "2023-07-08T15:23:47Z")

</div>

Yes.  
Column Rf (type Truncate Text) of table Taille  
Column Référence (type Text) of table Segmentation

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e1ca97c3786238ff5e942bbf0e94b56ac045add.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9030134abab4fe332be9b367eeb7e2c35b96562.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 8, 2023, 3:38pm UTC](https://community.glideapps.com/t/how-to-use-a-truncated-column-to-link-2-tables/63672/4 "2023-07-08T15:38:56Z")

</div>

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](https://www.glideapps.com/plugins/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.

---

<div class="post-metadata">

**Author:** ![zephir](https://avatars.discourse-cdn.com/v4/letter/z/e95f7d/32.png) [@zephir](https://community.glideapps.com/u/zephir)\
**Post date:** [July 8, 2023, 3:46pm UTC](https://community.glideapps.com/t/how-to-use-a-truncated-column-to-link-2-tables/63672/5 "2023-07-08T15:46:29Z")

</div>

Solved with Text Slice.  
Thanks.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 9, 2023, 3:46pm UTC](https://community.glideapps.com/t/how-to-use-a-truncated-column-to-link-2-tables/63672/6 "2023-07-09T15:46:45Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.