# Filter Table based on Rows of another table

**URL:** <https://connect.superhuman.com/t/filter-table-based-on-rows-of-another-table/5834>\
**Category:** Ask the Community\
**Created:** [January 10, 2019, 12:22pm UTC](https://connect.superhuman.com/t/filter-table-based-on-rows-of-another-table/5834 "2019-01-10T12:22:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Karim\_Noseir](https://avatars.discourse-cdn.com/v4/letter/k/45deac/32.png) [@Karim\_Noseir](https://connect.superhuman.com/u/Karim_Noseir)\
**Post date:** [January 10, 2019, 12:22pm UTC](https://connect.superhuman.com/t/filter-table-based-on-rows-of-another-table/5834/1 "2019-01-10T12:22:32Z")

</div>

Hi Guys,

I’m trying to filter this table (Investment Name Rows):

 ![33](https://global.discourse-cdn.com/coda1/original/2X/1/112c9919184fad8c721c27efe6ea786636e083a7.png)

Based on the rows (Investment Name) appearing in this table (i.e. show me the rows in date information which are NOT in Payment verification)

 ![38](https://global.discourse-cdn.com/coda1/original/2X/e/e902b21419ac1b61663f0dbc59bbf67750f00684.png)

The payment verifications get added when you press the Track It! button in table 1

Now, i’ve tried to do something like this in the Filter area of Table 1

```
[Investment Name]!=[Payment Verification].[Investment Name].unique

```

Playing around with this:

```
[Payment Verification].[Investment Name].Unique()

```

Returns ADNOC, PETROFAC

```
[Date Information]

```

Gives me ADNOC, PETROFAC, iO, Apple

However, I can’t seem to filter the Table based on the results of the first string. It just returns all the investment names.

---

<div class="post-metadata">

**Author:** ![Karim\_Noseir](https://avatars.discourse-cdn.com/v4/letter/k/45deac/32.png) [@Karim\_Noseir](https://connect.superhuman.com/u/Karim_Noseir)\
**Post date:** [January 10, 2019, 1:08pm UTC](https://connect.superhuman.com/t/filter-table-based-on-rows-of-another-table/5834/2 "2019-01-10T13:08:40Z")

</div>

So this:

```
In([Investment Name],[Payment Verification].[Investment Name].[Investment Name])

```

Works to show the two names that occur in Payment Verification. I have no idea why, or what [Investment Name].[Investment Name] is going (first is from Payment verification, second is from Date Information according to what’s highlighted).

Can someone explain what’s happening here?

Also, how would I adjust that to return the NOT

---

<div class="post-metadata">

**Author:** ![Karim\_Noseir](https://avatars.discourse-cdn.com/v4/letter/k/45deac/32.png) [@Karim\_Noseir](https://connect.superhuman.com/u/Karim_Noseir)\
**Post date:** [January 10, 2019, 2:23pm UTC](https://connect.superhuman.com/t/filter-table-based-on-rows-of-another-table/5834/3 "2019-01-10T14:23:31Z")

</div>

Actually that doesn’t work because it ignores the Payment Verification part and just returns the [Investment Name] from Date Information. So i guess Payment Verification is returning something in the wrong format for it to use whereas the Date Information isnt?

---

<div class="post-metadata">

**Author:** ![Karim\_Noseir](https://avatars.discourse-cdn.com/v4/letter/k/45deac/32.png) [@Karim\_Noseir](https://connect.superhuman.com/u/Karim_Noseir)\
**Post date:** [January 10, 2019, 2:53pm UTC](https://connect.superhuman.com/t/filter-table-based-on-rows-of-another-table/5834/4 "2019-01-10T14:53:02Z")

</div>

OK, it’s working but i have ZERO idea why, would appreciate if anyone could explain, especially the [orange].[purple] part of the formula

 ![58](https://global.discourse-cdn.com/coda1/original/2X/1/1899307f11263516ff9850792cb8be85d226206b.png)

 ![11](https://global.discourse-cdn.com/coda1/original/2X/3/3ca56807c0275f52e2849c20b30b6d51f7c6a1f2.png)