Hi everyone.

I have a question regarding a FME application where I want to compare certain measurements. The mesurements are imported to FME by LandXML format and the basic relevant data are the cordinates (X,Y and Z), the date of the measurement and the name of the point.

Example:

Data i imported.

2024-01-01:

P1; x=13,31, y=10,00;z=2,20

P2; x=11,21, y=9,87;z=2,10

P3; x=14,31, y=14,12;z=2,20

2024-01-02:

P1; x=13,32, y=10,00;z=2,19

P2; x=11,21, y=9,88;z=2,10

P3; x=14,31, y=14,12;z=2,19

P4; x=9,12, y=14,12;z=2,21

2024-01-03:

P1; x=13,33, y=10,01;z=2,19

P2; x=11,21, y=9,87;z=2,10

P3; x=14,31, y=14,12;z=2,19

P4; x=9,12, y=14,12;z=2,21

I want to import and generate graphs that shows the differences in plane and height (2 line graphs whit one line for each point and the date in x-scale) from the first measurement of the point. To complicate it a little further, as it shows it is possible for new points to be added later in the serie that will in later measurements be compared to the first measurement of the point.

Right i have these steps/boxes. I import data with LandXML importer, the I use a coordinate extractor followed by a list_exploder. The date is extracted by String searcher (regex).

The problem now is that i want to calculate the differences that is stored in the table that i got. One measurement of one point is always stored on one row with pointname and date, so the example above is now resulting in a table with eleven rows (3+4+4).

Then I would also like to write it in graphs. As a example the height graph would show 0 for P1 2024-01-01 as it appears the first time and -0,01 for 2024-01-02 as it is a little bit lower there.