# How to Filter a Multiple Relation **URL:** \ **Category:** Ask for Help\ **Created:** [June 9, 2021, 7:11am UTC](https://community.glideapps.com/t/how-to-filter-a-multiple-relation/27816 "2021-06-09T07:11:22Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [June 9, 2021, 7:11am UTC](https://community.glideapps.com/t/how-to-filter-a-multiple-relation/27816/1 "2021-06-09T07:11:22Z")
Hi!! I have a table that hase some records of pilots. And then I have another table that has these ones but one for each level. Table 1: Pilot 1 Pilot 2 Pilot 3 Table 2: Pilot 1 Level 1 Pilot 1 Level 2 Pilot 1 Level 3 Pilot 2 Level 1 Pilot 2 Level 2 Pilot 2 Level 3 Pilot 3 Level 1 Pilot 3 Level 2 Pilot 3 Level 3 I can relate the Table 1 to Table 2 in a multiple relation like you can see here: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f51b49af0ba76de91906b7e24fa4b13e4adf118b.png) But what I want now is to create a new relation in order to **FILTER** this one. I mean imagine that I have Pilot 2 at Level. Then I want to relate ONLY the Levels that I don’t have for that Pilot. Is there a way to do that? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 9, 2021, 8:04am UTC](https://community.glideapps.com/t/how-to-filter-a-multiple-relation/27816/2 "2021-06-09T08:04:26Z")
> [@adriasoce](#): > > But what I want now is to create a new relation in order to **FILTER** this one. I mean imagine that I have Pilot 2 at Level. Then I want to relate ONLY the Levels that I don’t have for that Pilot. Is there a way to do that? Do you mean let’s say Pilot 2 has Level 1, 2 but you have 4 Levels then your results would be Level 3 and 4? ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [June 9, 2021, 10:12am UTC](https://community.glideapps.com/t/how-to-filter-a-multiple-relation/27816/3 "2021-06-09T10:12:55Z")
Exaclty, this is because to level up a Pilot is need some coins and I want to rollup in a sup how much it costs to Level a Pilot to Level 4 if i’m in Level 2. Then I want to get in the relation the levels 3 and 4 because I want to sum them. ---
**Author:** ![Miguel\_Angel\_Vidal\_M](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miguel_angel_vidal_m/32/41284_2.png) [@Miguel\_Angel\_Vidal\_M](https://community.glideapps.com/u/Miguel_Angel_Vidal_M)\ **Post date:** [August 10, 2022, 9:56am UTC](https://community.glideapps.com/t/how-to-filter-a-multiple-relation/27816/4 "2022-08-10T09:56:23Z")
Did you find a solution? I think I have the same problem. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 11, 2022, 12:18am UTC](https://community.glideapps.com/t/how-to-filter-a-multiple-relation/27816/5 "2022-08-11T00:18:33Z")
Taking @adriasoce 's example. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f86b58911c68e0710eceac64084ef2ebe62f21b.png) You would have a “Level” text column to simply store a comma-delimited list of levels for the pilot. Then you split that to an array using the Split Text column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f3fa300112c520c1b33ae414440747ce8341b0a7.jpeg) Next, you create an array of all levels using the Make Array column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/285bfab38cd57e2ae4d35b6105a1629c764279ac.png) Finally, you create a “Remove Elements” column to get the final result. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f37befc6ec35b79641fcf62bb9b2b16273f7dbae.png) You can then use the final array to create the relations as needed.