How can I use correctly de Relation function?

[EmilioPartida]

I need to relate the data from the “Cantidad” column in the “Fechas” table to a new column in the “Resumen” table, but they need to be related through the “Mes” and “Año” columns. I’ve tried several ways, but none of them work. How can I do it correctly?

[Jeff_Hager]

Try using a Query column.

[EmilioPartida]

I’ve already tried using Query, but it only selects the “Fechas” table; it doesn’t let me select the column I want.

[Mazen]

Use Lookup or Single Value

[EmilioPartida]

I’ve also tried using Lookup and Single Value.

Lookup it might work, but I don’t know what to do next. Can I apply a filter to this column or something like that?

[Jeff_Hager]

@EmilioPartida

it only selects the “Fechas” table;

You have to set the filter in a query column. You start by selecting the table and then you need to set the filter to get the matching rows you want.

Query Column | Glide Docs

[Robert_Petitto]

Video is a year or so old — but it might help:

Glide 101: Query Column Replaces DOZENS of Computed Columns

[EmilioPartida]

Thanks a lot! @Jeff_Hager @Robert_Petitto, it worked well with those videos!