Transformers

I have a dataset which contain null/non-null values in a particular column, I have to segregate it in the way that if any null value exists, all null/non-null values will go in 1 direction else only the non-null values will go in 2 direction (port), help?

I'm having trouble pivoting a table. Here is what I am trying to accomplish: Is the AttributePivoter the correct transformer to use? Thanks in advance, M

Good day, I would like to ask. I am currently solving the tracks in the WS in the attachment. I ran into a data "loss" issue happening on featureMerger. Points from the polygon of interest go to the Requestor's input, and points with the same ID as the requestor's input go to the Supplier's input - these points are part of the RouteSegment. Now to my problem. I believe that I don't have all the data on the FeatureMerger output because I only have each point once on the requestor input, however, I can have a point multiple times on the suplier input and it can be part of different routeSegments. At the moment when a point at the requestor input is "reserved" by the first point of the same ID on the supplier, at that moment the rest of the data goes to the Rejected output. I can think of creating X featuremergers, where I would send the rejected data to the input of the supplier and the original polygon_selection_topsky source to the requestor. But I find it quite daunting. I vaguely rem

I'm new to FME and impressed by what can be done with it. However, I got stuck regarding some details. I have a PointOnAreaOverlayer transformer and I wonder why the Point output port let's me use all attributes, whereas the Area output port generates no output for some attributes that I need to use. What is the solution here? Thank you!

I am constructing a workspace that builds a file geodatabase from a schema specified in Excel. Each worksheet row defines an attribute and its feature class and feature dataset hierarchy (and domain, if any, but that will be for another day). The schema has feature classes mostly nested in feature datasets but some are root level. For testing, I have extracted a small sample of the schema, representing thirteen combinations of feature dataset and feature class with one feature class at root level. Now, after Excel file reading and subsequent processing, near the end of the workflow the attribute records go through an Aggregator transformer, which creates the attribute{} list attribute. The result is thirteen schema features. Schema features exiting from the Aggregator have no geometry, of course, and consequently have fme_type=fme_no_geom and fme_geometry=fme_undefined. I created and set the following attributes on each schema feature to hold the values that I want to specify as the ge

I have thousands of data, and each datapoint has six attributes, which I want to store in one list per data point. Which transformer could be used for this?

Hi, I need to work with a file that uses EPSG:5682 as CRS but unfortunately it's not available in the CS Gallery. I tried to add it as a custom CS, as described in the online documentation but it's still not showing up. This was my workflow: I went to the online tool and pasted the ESRI WKT for EPSG 5682 I entered the missing parameters (that weren't already populated from the WKT) I unzipped the files provided by the tool and copied them to ..username\\Documents\\FME (see attachment) After restarting FME, the custom CS is still not available in the gallery. Did I miss something? Thank you for your help!

Example: We have a layer with employees. Each employee has their own unique polygon. We can easily go in and create unique symbology for each person. We can use hashing and colors to allow overlaps. The issue is finding a way that every time someone new is entered in the employee database, they get symbology automatically setup. In other words, does anyone know if FME can create a new layer file, symbolized with rules, that accounts for new rows/values. We were hoping to find something in ESRI solutions but haven't so far. So now wondering if FME can just automatically recreate the base layers files that the map service would ultimately consume. Thanks

I am downloading data through an API from OS open source. The connection is set up correctly and the data is downloading when ran but it downloads several versions of the data in several formats such as SHP file, GML and Geotiff. For my project im working on I only need the shapefiles but I cannot figure out what tool to use to filter the rest of the unwanted data types out correctly. Or maybe its not a tool and its done in the JSONfeature parametres? I have attatched some photos below so I hope it helps clear up any questions.

The above image should explain the issue. I have tried AreaGapAndOverlapCleaner which fills the donut and dissolves with 1 of the polygons (I have chosen the polygon with the longest boundary at present), which results in below. This is ok but ideally I want the donut evenly split across both polygons. Is this possible? Can anyone recommend a transformer or number of them to get my required output?

Hi, I've a bunch of features relative to adresses and associated inhabitants. I've already grouped the features by similar street names and numbers wich results in the "match_id" column. What I need now is to sum each four "total..." column's value (separately) by using the "match_id" as grouping value. The goal is to get the number of peoples, etc ..., living at one adress. I've tried several transformers after the AttibuteManager but none return the attented values. Thanks for your help

Please can someone tell me how to write a WHERE clause in the feature reader that excludes records that do not contain a value. I have thousands of records and some of them have a Global ID - I want to keep these records. I also have records that contain NULL or no value - I want to exclude these values. I can perform this function in a Tester, but a colleague informed me having this clause built in to the feature reader instead will be much quicker. Perhaps someone can confirm this. Thanks, Frank

Hi everyone, I need to retexture a citygml file using one (mosaic)image file. But I am facing an issue in the last steps using the Appearance Setter. I started with the WallSurfaces and managed to calculate the (row,column) coordinates of each wall-vertex on the new single image (derived from the previous textured model that used multiple images for one building in the appearance folder). The position of a (sample) wall3D projected on the mosaic-image looks correct, attached a screenshot from QGIS. I rescaled the row column coordinates to a 0,1 scale, with (0,0) representing the lower left corner of the image, and stored them as list-attributes for each wallsurface. I used these lists to set the u,v texture coordinates with the measuresetter transformer as explained in this useful post on texturing citygml : https://community.safe.com/s/question/0D54Q000080heXzSAI/3dcitydb-texture-coordinates Afterwards I used the appearance setter, connecting the imagemosaic to the appearance input, t

Hi all, I have a couple of point features which are feeding through with polygons (as the points should join to polygons, bar these 2). I've tried the GeometryCoercer and CenterPointReplacer etc but no luck. Is there something I'm missing which could create even a small polygon from a point?

My dataset contains multiple points within different towns. For example, town A will have 30 datapoints and town B has 35. Can I automatically create output ports to group the relevant datapoints by each town without having to filter them all manually?

Sample data from the gml file: ` <gml:featureMember> <nzodn:physical_oceanographic_map fid="physical_oceanographic_map.fid-4332c03c_1829f0e6782_-2349"> <nzodn:stationName>U3693</nzodn:stationName> <nzodn:url>https://nzodn.nz/data/physical_oceanographic/sage/SAGE_CTD_data_U3693.txt</nzodn:url> <nzodn:time_coverage_start>2004-04-07T10:50:00</nzodn:time_coverage_start> <nzodn:time_coverage_end>2004-04-07T10:50:00</nzodn:time_coverage_end> <nzodn:hasTemperature>true</nzodn:hasTemperature> <nzodn:hasSalinity>true</nzodn:hasSalinity> <nzodn:hasChlorophyllFluorescence>false</nzodn:hasChlorophyllFluorescence> <nzodn:hasTransmissionOfLight>false</nzodn:hasTransmissionOfLight> <nzodn:hasFluorescence>false</nzodn:hasFluorescence> <nzodn:hasPressure>true</nzodn:hasPressure> <nzodn:hasDissolvedOxygen>true</nzodn:hasDissolvedOxygen> <nzodn:hasComment>false</nzodn:hasComment> <nzodn:geom> <gml:Point srsName="http://www.opengis.net/gml/srs/epsg.xml#4326"> <gml:coordinates xmlns:gml="http://www.opengis

I have a workspace that converts a DWG file to a new DWG utilizing a template file. However, I am unclear on how the text styles saved in the template file interact with multi text features written to the output DWG. I understand that the template file will overwrite any styling you set in the workspace for lines, polygons, and blocks. Does this also apply to text? Here are the details, In my workspace I set the text style with the property autocad_shape_name to a corresponding style in the autocad template file. Also, the multi text features are put on a layer that exists in the template file. I have been trying to modify two attributes in the text features that are found in autocad (Annotative, and Defined Width), see the image below showing these properties highlighted in AutoCAD. However, I can't seem to set these attributes at all. Theoretically, if fme utilizes text styles from a template file, the "Annotative" property should be set correctly in the ouput (it's not) by the text

I would like to iterate through a table based on a list of values. This is the process I would like to automate: Filter the table on a value then add an attribute and BulkAttributeRenamer. I have 20 values so I'd like to be able loop through the table for each value rather than have a set of transformers for every value.

Hi, I'm looking at using FME server to create our Cesium3DTilesets, rather than using the native Cesium ION on-premise tiler which we're using at the moment, so we can streamline some of our processes along with a bit of exploration. Say I have 4 OBJ photogrammetry models originally created using ContextCapture. Each OBJ file represents a building: Building1.obj Building2.obj Building3.obj Building4.obj I want to create one Cesium 3D Tileset from these building objs. I also would like to add some metadata to the generated tileset.json/b3dm files to specify which .obj they were originally referenced to, e.g. the tiles batch Id could be set as the name of the original obj for example. The reason for this is to be able to distinguish which building is which when streaming the model in an application such as CesiumJS. It needs to be one tileset that is generated rather than one per obj, as one tileset is much more performant than streaming data for each separate tileset. On a small scale m

Similar to method here: https://forums.autodesk.com/t5/civil-3d-forum/how-to-create-surface-or-solid-to-model-existing-tunnel/td-p/8551041 I have as input a underground tunnel in MESH (pointcloud also available). I want to convert this MESH to 3DSOLID DWG. One idea was to take every single polygon of the Mesh and use the Extrude in the right direction, or the 3DBufferer (takes too long) to create a solid object before writing to DWG with RealDWG-writer. However this does not seem to be very pretty or fast on large sections. Is there a better approach to generate a solid object from a tunnel with FME?

Dear Sir/ Madam, So I would like to reproject my CityGML model (ground surface) from EPSG 2326 to EPSG 3857. However, I notice that the area is changed, even though they are both in meters. May I ask if is it normal? Is there any reason behind this? Thank you very much. With regards, Zach

I tried using Appearance setter for KMLwriter but didnt able to get the result. Appearance setter worked for CityGML output but not for KML output.

Hi, I have a (complete) road network containing all the "real" roads segments of the road network. I then have several "copies" of the road network but with different segments, these segments define attribute properties for the road segments. I want to split the "real" segments by multiple attribute segments. e.g.: Road 1 -------------------------------------------- 5m 10m ---------|----------------------------------- 70km/h 50km/h 70km/h --------------------|-------------|---------- Desired output: 5m 10m 10m 10m --------|-----------|-------------|---------- 70km 70km 50km/h 70km/h Does anyone have a good solution for performing this in FME?

I'm using a coordinate system that is not in FME’s Coordinate System Gallery. I added a custom coordinate system by creating a new .fme file and using the online tool. When I use it in my FME model it give me the message: "Invalid longitude value given for projection origin". My .fme file has this information: COORDINATE_SYSTEM_DEF PTRA08-UTM/ITRF93 \\ DESC_NM "PTRA08 / UTM zone 26N EPSG:5015" \\ GROUP EUROPE \\ EL_NAME GRS1980 \\ ORG_LAT 0 \\ PARM1 -27.0 \\ PROJ UTM \\ QUAD 1 \\ SCL_RED 0.9996000000 \\ SOURCE "https://www.dgterritorio.gov.pt/geodesia/sistemas-referencia/regioes-autonomas/PTRA08-UTM-ITRF93" \\ UNIT METER \\ X_OFF 500000 \\ Y_OFF 0 I think the error is in PARM1, but I think it's ok... -27