Forum Discussion

IF's avatar
IF
Post Prodigy
3 years ago
Solved

Filter by another field

Hi,   I have two tables. Table 1: NameType A X1 A X1 B X2 B X3 B X4 C X2 C X3 C X3 C X1 D X1   Table2: NameQty A 2 B 3 C 5 D 7 E ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi IF ,

     

    I got this:

     

    First you have to group Type by Name all rows, you would get this table:

    Then you have to get the column of Type from this column table as list, you can do it with this formula:

     

    Then you have to expand the list with "," delimited for example and remove the column table, you would have your table like this:

    Then you just have to merge with the other table by Name column, and filer the column of Types by Text Contain, and i get that i think you need:

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi IF ,

 

I got this:

 

First you have to group Type by Name all rows, you would get this table:

Then you have to get the column of Type from this column table as list, you can do it with this formula:

 

Then you have to expand the list with "," delimited for example and remove the column table, you would have your table like this:

Then you just have to merge with the other table by Name column, and filer the column of Types by Text Contain, and i get that i think you need: