# Merging Relation columns
**URL:** https://community.glideapps.com/t/merging-relation-columns/64515
**Category:** Ask for Help
**Created:** [July 30, 2023, 4:43pm UTC](https://community.glideapps.com/t/merging-relation-columns/64515 "2023-07-30T16:43:40Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Elise\_Jordan](https://community.glideapps.com/u/Elise_Jordan)
#### Post date: [July 30, 2023, 4:43pm UTC](https://community.glideapps.com/t/merging-relation-columns/64515/1 "2023-07-30T16:43:40Z")
Hello,
I would like to create a third column made of the results of two relations columns but this seems impossible through the make array function…
Do you have any idea how I could do ?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [July 30, 2023, 4:47pm UTC](https://community.glideapps.com/t/merging-relation-columns/64515/2 "2023-07-30T16:47:59Z")
Relations only create links to entire rows in the other table. If you need a specific value from that relation, then you also need Lookup columns to return an array of values from a specific column in those related rows.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 30, 2023, 11:26pm UTC](https://community.glideapps.com/t/merging-relation-columns/64515/3 "2023-07-30T23:26:28Z")
Once you use lookups like Jeff said, you can use an “Append Array” column to join the two arrays. But beware of the case when the “first array” in your setup is empty, you may get a result of empty although your second array contains items.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [July 30, 2023, 11:49pm UTC](https://community.glideapps.com/t/merging-relation-columns/64515/4 "2023-07-30T23:49:38Z")
> [@ThinhDinh](#):
>
> “Append Array” column
I find the “make array” column to be faster, no?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 30, 2023, 11:52pm UTC](https://community.glideapps.com/t/merging-relation-columns/64515/5 "2023-07-30T23:52:44Z")
Ah that’s a good catch. Using “Make Array” would also solve the problem of “first array being empty”. Thanks for the tip.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [July 31, 2023, 12:05am UTC](https://community.glideapps.com/t/merging-relation-columns/64515/6 "2023-07-31T00:05:54Z")
> [@ThinhDinh](#):
>
> Thanks for the tip.
My pleasure entirely!
---
### Author:  [@Elise\_Jordan](https://community.glideapps.com/u/Elise_Jordan)
#### Post date: [July 31, 2023, 10:22am UTC](https://community.glideapps.com/t/merging-relation-columns/64515/7 "2023-07-31T10:22:08Z")
Thanks a lot for your replies !
It helps a little but still I am having troubles reaching my end goal 🥲
**To give a bit of context :**
I have 2 types of spendings with different categories associated (Housing, Meals, Activities …).
My end goal is to have a radial chart that gives me, filtering per month, the repartition of those spendings per categories.
I managed thanks to [your tutorial](https://www.youtube.com/watch?v=AVSavEhdt6Y) Robert to make a filter on one type of spending from a table called “bills” and have this outcome which is already great :
Now I would like to add to this same chart the spendings from my table called “Incompressibles” (sorry for the French 🫣).
Since it has the same structure as the “bills” table I thought merging two relations columns could help me however the Make Array solution does not allow to “keep the information” such as the category in a label.
I have the feeling my only solution would be to manage putting the “Incompressibles” table in the same one as the “Bills” table to finally have one relation only…
---
### Author:  [@Elise\_Jordan](https://community.glideapps.com/u/Elise_Jordan)
#### Post date: [July 31, 2023, 1:31pm UTC](https://community.glideapps.com/t/merging-relation-columns/64515/8 "2023-07-31T13:31:33Z")
Quick Update : I indeed merged the two tables into one (and added one column to mark the type of spending rather than having two tables is actually better).
My last problem is that it seems not all categories are shown in the radial chart (8 displayed when I have 11 in total).
Is there a limit in the labels displayed in charts ?
FOUND IT ! It was actually in the page size that I had to go beyond 24
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 1, 2023, 12:43am UTC](https://community.glideapps.com/t/merging-relation-columns/64515/9 "2023-08-01T00:43:48Z")
Great to hear it worked.
> [@Elise\_Jordan](#):
>
> I indeed merged the two tables into one (and added one column to mark the type of spending rather than having two tables is actually better).
This is an important move for you. When you have data that follows the same structure, doing it this way is good practice.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [August 2, 2023, 12:44am UTC](https://community.glideapps.com/t/merging-relation-columns/64515/10 "2023-08-02T00:44:13Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.