I am using InlineQuerier to lookup a value and add it as an attribute to my base table (Cities). For audit purposes I want to lookup multiple values and add multiple attributes before performing calculations. Currently I am using a separate InlineQuerier for each additional attribute. Can it be done in one? or using other tools?

As an example say the base table is Cities, and I want to look up several different price indexes in a CityIndex table based on specific dates, and add these to the base table. See pictures.

To add one attribute I can use an InlineQuerier function:

Select Cities.*, CityIndex.IndexValue as Index_at_20210630

from Cities Join CityIndex on CityIndex.City = Cities.Name

where IndexDate = "20210630"

But how can I add multiple attributes - see desired state screenshot attached?

Many thanks

Philip (6 month FME user)