Another solution for this question.
Community: Calculate the time difference between two features in a non-spatial dataset
Table columns definition in the InlineQuerier:
SQL query statement is:
-----
select a.SiteName, a.SampleDateTime,
case
when b._count is null then null
else round((a._epochtime - b._epochtime)/3600.0, 1)
end as TimeSinceLast
from Source as a left outer join Source as b
on b.SiteName = a.SiteName and b._count = a._count - 1
-----
Result:
btw, why there is not datetime type for setting input table columns in the InlineQuerier?
FME 2014 SP3 build 14389
=====
Dale@Safe replied to my question. See his comment. Thanks, Dale!
Welcome! This blog is my personal memorandum about FME. Feel free to leave your comments. ようこそ!このブログはFMEに関する私の個人的な覚書です。コメントを歓迎します。欢迎您!这博客是我对FME个人备忘录。感谢您的任何意见。
2014-08-22
2014-08-21
Take a look at FME 2015 beta
I tried FME 2015 beta build 15158.
Don and Dale introduced this new feature at the UC. That was very impressive.
I like this :-)
And, welcome the grid coming back with further enhancements!
Of course there are many enhancements and improvements internally.
I look forward to the release.
Don and Dale introduced this new feature at the UC. That was very impressive.
I like this :-)
And, welcome the grid coming back with further enhancements!
Of course there are many enhancements and improvements internally.
I look forward to the release.
2014-08-09
Split Solid or Complex Surface into Individual Faces
The GeometryCoercer (Geometry Type: fme_composite_surface) and the Deaggregator (Split Composites: Yes) can split a single Solid or a complex Surface (e.g. TIN surface) into individual Faces.
Community > Trying to extract faces from a solid
Community > Trying to extract faces from a solid
2014-08-03
Custom Transformers for FME Store
still busy...
I uploaded these custom transformers to the FME Store (Category: Pragmatica).
-----
DateTimeCaluculator
JpStdGridAccumulator
ListMerger
ListSampler
ListSlicer
ListStatisticsCalculator
RadiateLineGenerator
RegxAttributeSplitter
-----
Please evaluate them ;)
I uploaded these custom transformers to the FME Store (Category: Pragmatica).
-----
DateTimeCaluculator
JpStdGridAccumulator
ListMerger
ListSampler
ListSlicer
ListStatisticsCalculator
RadiateLineGenerator
RegxAttributeSplitter
-----
Please evaluate them ;)