I am trying to use the Inline Querier to join some data together from 2 sets for inputs CSVs, but am having some problems writing the query. Can someone help?
‘Table 1’ consists of the following fields
1 SurveyDate (yymmdd)
2 X
3 Y
4 Value (INT)
e.g.
140211
1000
2000
15
‘Table 2’ consists of the following fields
1 SurveyDate (yymmdd)
2 StartValue (INT)
3 EndTime (INT)
4 Road (Text)
5 Carriageway (Text)
140211
10
500
FME Street
L(eft side)
I am trying to complete join which is as follows
SELECT *
FROM
Table 1, Table 2
WHERE
Table1.SurveyDate = Table2.SurveyDate
AND
Table 1.Value >= Table 2. StartTime
AND
Table 1.Value<Table2.EndTime
I need to do various FME operations before and after the join, therefore ideally I want to the query within FME rather than having to write out the data, use a DB to perform the join and the and reread the data back into FME.
Thanks in advance.