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)