Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I am trying to extract records from one table based on a series of date ranges in another table. I want all the records from table A, that fall between date ranges from table B. Each table B row has a start date and end date.
I am trying to extract records from one table based on a series of date ranges in another table. I want all the records from table A, that fall between date ranges from table B. Each table B row has a start date and end date.

@zanzibarjack​ If the data is in a database then you can use SQLExecutor to run a SQL BETWEEN query on the two tables. If the data is form Excel or CSV then you can do the same query, but using InlineQuerier

@zanzibarjack​ If the data is in a database then you can use SQLExecutor to run a SQL BETWEEN query on the two tables. If the data is form Excel or CSV then you can do the same query, but using InlineQuerier

Thank you or your response. I hoping to automate the process instead of manually typing in each date range. The date ranges are coming in from a separate table than the records I'm trying to filter.

Thank you or your response. I hoping to automate the process instead of manually typing in each date range. The date ranges are coming in from a separate table than the records I'm trying to filter.

You'd make one call to table containing the dates, then use those vlaues in an AttrbiuteCreator to create the WHERE clause and pass that into an SQLExecutor or FeatureReader

@zanzibarjack​ There's an InlineQuerier SQL example by @Takashi Iijima​ here

Reply


Community Stats

30,168
Posts
114,528
Replies
37,826
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.