Hello, I have two tables, I would like to filter the result based on other table's column values. I tried using nested filter but that show error. Here's the code.
Filter(ArchcorpSpace_Table, ID in Filter(AssignSubzone_Table, Date_Assignment = Text(Today())))
The error it show is: invalid schema, expected one column table
I know this error would come up because I need to tell which 'ID' of ArchcorpSpace_Table should match with which column of AssignSubZone_Table. But I don't know the correct syntax.
My Table has the following structure.
-------------------------------------------
ArchcorpSpace_Table:
ID
Name_Space
ArchcorpSubZone_Table:
ID
Name_SubZone
Date_Assignment
ID_Space
The desired output I want is:
Filter the all Name_Space who has been assigned today in ArchcorpSubZone_Table
-------------------------------------------------------------------------------------------
Thank you
