Change the column name the FILTER shows

I have a formula that extracts values from a Spreadsheet “Warengruppen”:

FILTER("Warengruppen", IN([Modell], [_THISROW].[DescrParts]))

“DescrParts” is on of the virtual columns. AppSheet interpreted this as following:

The list of values of column ‘Name’
…from rows of table ‘Warengruppen’
…where this condition is true: ((The value of column ‘Modell’) is one of the values in the list (The value of ‘DescrParts’ from the row referenced by ‘_RowNumber’))

I need to have column “Hersteller” instead of “Name”. How can I do this?

3 Likes