Transformers

I need to build something in FME where it automatically selects all ID entries and then looks at another column with values and selects the row with the highest value, and delete the other rows with the same ID. in the screenshot i have 2 columns: Risicoprofiel_BEREK and ID, in ID there are multiple entries which i need to select and then find the highest value from the Risicoprofiel_BEREK column. 

Hi there,I am creating a data frame that has two columns i.e. date and time on Python caller (at init function). I used the "attribute to expose" field to display the value of data frame. When I ran the translation, it made the dataframe column in the output but values were missing. I also tried to display the data frame value using column-wise but no luck. Could anyone tell how to add data frame at the output using Python caller?

Hi!TLDR: Writing a 3DS from a IFC with scaling of 0.001 and reprojecting from a local coordinate system to SWEREF99 12 00 I loose model quality, scroll to last pic. Info:I'm trying to convert a IFC model to a format I can use with GIS and Specifically import into ArcGIS PRO / Online. Shape Multipatch writes fine and the quality is there, but file size get big quickly and I loose textures with this writer.  Writing from IFC to 3DS without any other transformers yeilds a good result on my model: This quality pretty much looks identical to my INPUT IFC.If I Scale it 0.001 it also looks acceptable:if I only reproject I can see some small artifacts, why does this happen and can I fix it?

Hi,I am trying to use the LengthToPointCalculator in 3D mode however whenever I run my workflow I get the following warning message: WARN |@Length -- Cannot calculate length to a point in 3D. Continuing using 2DThe line geometry is definitely 3D as I can see the elevations for each vertex in the Inspector. Has anyone else experienced this and if so, do they have a solution?I am using FME Desktop 2019.1Thanks, 

We are converting 100s of DGNs to DWGs. All of our complex shapes (that have an arc as a component of that shape) in DGN are being converted to splines in DWG. We want to drop all splines to polylines, while still maintaining the arc information. Is there a way in FME to do that?

Hi guys,I have three Excel files which need to be converted into a Esri file gdb as three tables.As a schema for each of these tables I want to use three other tables which are stored in a gdb. I imported the last mentioned tables as readers and tried to implement their schemas in the writer of the first three tables using 'Schema definition'.However, I got an error when running the translationI am doing something wrong?

I am running a query similar to below, but FME does not recognise the geometry, at least it does not show geometry in the inspector, only tabular data with my geom column with binary as string? I have also cased the geometry to EWKT and WKT, but I cannot find how I can make FME create geometry from either WKT or EWKT so I can continue with my workflow?select ST_Union(Geometri_SPA) as geom from xwhere ....UNIONselect ST_Union(Geometri_SPA) as geom from xwhere....UNIONselect ST_Union(Geometri_SPA) as geom from xwhere....

Hello,I'm trying to select the polygons that are cut by another polygon (Boundary Box) (polygons that are completely inside or completely outside the Boundary Box polygon are of interest to me). My attempts with the SpatialFilter and SpatialRelator ("Requestor Touches Supplier") all failed. Are there any other possibilities? I have a shapefile as source data and the boundary box polygons are created from LAS files using BoundsExtractor and BoundingBoxAccumulator. Thanks a lot in advance

Hi AllI am working on an electric network as input where line segments sometimes join. The end vertices lie on top of each other. I have used the Snapper and LineCombiner to combine lines where only two lines meet. The LineCombiner transformer can however not combine lines where more than two lines meet.It does not really matter what two lines are combined, although it would make sense to join the longest segments. The line segments all have the same attribute values (ie the same voltage and reticulation name). The reason for wanting this is to make the output dataset as small as possible, as there is so much unnecessary duplication with the attributes for small pieces of line being exactly the same.Is there a way to combine two lines where more than two meets?Hope someone can help.

HelloHow to simply perform a sql operation of union of 2 different database tables ? (not a join)thanks

Hi there, Need a suggestion from FME's experts. I have FME transformation that calculates two fields based on the data coming from different sources. Now, I want to use the calculated field along with some other fields from the data and perform normalization on it. I have already written a script in Python (separately) which performs normalization. The Python scripts contains while loop and comparison operators. Is there any way of calling the external Python script from FME? What do you suggest

I have successfully created an FME Workspace Runner Python script that will launch Workbench (Desktop) and start an FME conversion process. This is an effort on my part to eventually sell the idea of purchasing FME Server. Everything works quite well, with exception to one small glitch. I cannot seem to get the script to automatically retrieve the appropriate files (based on date as per below) to include in the process. Currently, before I run the Workspace Runner I need to first (manually) include all of the files that I would like FME to convert in an FME Reader, but I would like this step to run entirely from the Python script.I think I know where the problem is (see below in blue), but I don't know how to remedy the parameters (if it's even possible).The data in question is referred to as NMEA data (National Marine Electronics Association) and is basically Ship born GPS data that is standard in most GPS units today. Below is an example of the dat

I am using the JSONTemplater with such Root Expression:  {     "Code" : fme:get-attribute("Code"),     "Nom" : fme:get-attribute("Nom"),     "C3" :         [           {             "label" : "2006",             "value" : fme:get-attribute("C3_EII06")         },{             "label" : "2007",             "value" : fme:get-attribute("C3_EII07")         },{             "label" : "2008",             "value" : fme:get-attribute("C3_EII08")         },{             "label" : "2009",             "value" : fme:get-attribute("C3_EII09")         },{             "label" : "2010",             "value" : fme:get-attribu

Hi all,I am specifying the AutoCAD Layer color by a given attribute 'Category' which is being filtered using 'AttributeFilter' transformer and redirected to each DWG Writer to specify the AutoCAD Layer Name and color. All the below DWG Writers are a single DWG Output File. For some reason, when no features are written to some of the above DWG Writer, I still have that AutoCAD Layer Name written as below, even though no features have been past through the attribute filter so I am not even sure why that Layer 1, Layer 100000, etc. is being set.Any help would be highly appreciated. Thanks,Ana

Hello, I am trying to clip polygons which are outside of a shape boundary. Basically as attached image, I'd like to clip/ erase all yellow selected polygons. The first step is working to clip ortho photo and generate polygon terrain from boundaries. But the "left" over polygons in between (with no ortho photo) are the ones which would need to be erased.I've tried deaggregator to get all polygons from the generated terrain and feed into the clippee. The Clipper is the shape polygons from first image. No success so far.I appreciate any ideas.Thanks!    

i used line combiner to join more than segment line and lines intersects with another lineseach line has around seven segment line so i used line combiner to join more than segments of line and also join the next line that intersects.so i have now long line and it is working so nicely but i have still question if i need also to export the id of each line that intersects with next line to make long line .so if 5 lines intersectes in nodes so i need id for each line that intersected with neighbour line.so as example for 5 lines connected i need five lines id plus the whole new id for the long line that contains 5 old id line.really i learned alot from FME Community and from membersThanks alot 

Hi,After spending some times on creating a pointcloud from a 3D Polygon, I realized that the PointcloudCombiner does not correctly interpolate on a 3D Polygon. So the workaround is to create a pointcloud with PointcloudCombiner (Points elevation are WRONG) > Pointcloudcoercer (to multipoint) > SurfaceDraper (Drape multipoints on 3D Polygon).I think that the pointcloudCombiner should handle the conversion or at least write it in the helpsheet.ThanksFlorian

I am using SpatialRelator to merge attributes from intersecting features B, C, D etc onto feature A. The number of supliers varies from 1 and upwards 4-5. My problem is that the transformer only seems to read the first intersecting suplier that enters, and then moves on. Any ideas on how to solve this and merge the attributes from all incoming features? 

Hello, I'm having troubles with exposing FME Feature Attributes with the SQLExecutor. I use the SQL Executor with this statement:And therefore I entered these attributes to be exposed: I would like to add the FME Feature Attribute ‘SAMPLE_NR’. - How do I need to add the attribute to the SQL statement? - And what should I put as ‘Attribute to Expose’? I tried this:With the term SAMPLE_NR or '' or as Attribute to Expose. But each time I get the value <missing> in the SAMPLE_NR column.   Thanks in advance f

Hi there,I have two tables that I want to merge using feature joiner. I am doing a left join. I want all the rows of the left table to come in the output table. When I ran the program, most of the rows from the left table, however, I found that about 100 records went into the rejected output field. When I investigated I found that the column I used from the left table to join has null values and that goes into the rejected output field. Could anyone guide me on how could I make sure that all records from left table come to the output table? 

Hello,  I am attempting to round the xy coords of a point cloud.  I am using a PointCloudExpressionEvaluator.  This is the expression - @round(@Component(x))  But it is throwing the following error;  PointCloudExpressionEvaluator (PointCloudEvaluationFactory): Failed to parse the EXPRESSION_LIST clause. The provided value was '@round(@Component(x))'. Please ensure that your syntax is correct  Round does not appear in the PointCloudExpressionEvaluator in the Math Funtions list, does this mean it is not available?  Ben

In *.dwg I've got some roadmarkings which I would like to export to fbx. In *.dwg that's a linetype.The roadmarkings are default polylines, How can I get the same view from a dwg in a fbx?Could I for example divide the line into pieces (3m roadmarking, 9m empty, 3m roadmarking etc), and...I would like to have them in 3D Thanks!

Hi all,I'm a newcomer to FME from the geospatial side of things and have inherited a somewhat large model of complex geometric operations (clips, intersects, bounding boxes etc...). On trying to run the model (with data and a workbench that has, supposedly, succeeded in 2018) I always encounter this "data shattering" warning leading to a fatal error.Hit data-shattering case as 55 new nodes were created after phase 7, compared to 2 nodes created after phase 1To resolve the above issue, try setting a tolerance if your transformer has a Tolerance parameterError running translationI believe I've narrowed the problem down to a NeighborFinder operator, and have attached screenshots of the processes leading into it, as well as its parameters. 

Hello guys , iam tired from tryng doing that and i could not get the result that i want .i have many lines and some blocks in the map ,and i want to find neighbour step by step and give each line that i can find new id as temporarly id .when the line touch the block so another lines touched the same block give them new id .so how can i do that tried alot by line divider and neighbout finder but i did not success or by 2 coordinate extractor(tart point and end point ),2 vertex creator also then neighbour finder but i i did not success ,please could u guide me what should ,i need to find the neighbour give new id for the neighbour that u find then continue fom next neighbout to find the next and so on but sometimes map has blocks not only lines.Thanks in aadvance for helping

FME(R) 2019.2.2.0 (20200103 - Build 19817 - WIN64)When clicking on the icon with the magnifying glass, the data is not displayed in the visual preview. The user has to click once more on this icon to get the data source.