Transformers

Hello all, I frequently used the FeatureMerger or FeatureJoiner transformers. However, none of them seem to offer a join based on an expression, such as checking if a value from one table contains a value from another table. How can this be achieved? Thanks for any assistance.

I have a polygon layer that was digitized manually and as a result, has some issues with overlaps and gaps. However, the first issue I would like to solve is making the polygons have right angles. They are all square or rectangle-type shapes so each vertex should have a 90 degree angle. Is there a way to manipultate the polgyons so that they are all at right angles? At this point, I would be able to check for snapping and other issues. Thanks!

I am trying to reproject a wms from the Environment Agency (https://environment.data.gov.uk/spatialdata/risk-of-flooding-from-surface-water-extent-0-1-percent-annual-chance/wms) from WGS 1984 to British National Grid. I need to know the cell size so I can provide a degree of accuracy of the data and have confidence in my areas of intersect calculations with some polygons. However, when I use the Reprojector, the spacing seems completely off. If I view it in ArcGIS Pro, the cell size appears to be 2m, which seems sensible. I have tweaked the parameters in the Reprojector but this doesn't give me the correct cell size. Any ideas what I'm doing wrong?

I have an Esri ArcGIS Binary Grid and a line shapefile. The shapefile was produced by the Surface Draper transformer, so it is 3D and has Z values at the verticies from the same Grid. The Z values that I would like to generate at a 10m interval can be output to a csv, instead of being applied to the shapefile: that is, I do not require verticies to be created in the shapefile at a 10m interval. Just need the interpolated Z values every `10m down the line. Thanks!

To ensure our database's data integrity, which is periodically enriched with measurement data governed by users, we use FME to create data validation reports in Excel. With these reports, users can correct their data iteratively.  To make this work, we use SQL statements stored as attributes in a table. Depending on the report to be generated, SQL statements are fed into a SQLExecutor transformer as attributes. At the time of writing, we employ close to 500 validation queries, each with their own set of columns as well as amount of columns. The picture below shows how the queries are inserted into the SQLExecutor as an attribute.  This is then routed to a dynamic Excel writer by using the SchemaSetter custom transformer. The Excel report is generated as expected, except for the column order, which

(Disclaimer: I have only rudimentary understandings of the inner workings of XML.)The source below is a GML file where I need to fragment/flatten the elements shown. I would like to be able to treat them as "normal" features with regular attributes. I am using the GML-reader associated with this specific data source, Norweigan SOSI, my settings are also below.  Q: What would be the best way to flatten this data?  (Or would the XMLfragmenter be a better tool? I must admit I find all this a bit confusing)    

Hi there,I'd like to add an arcgis online feature service to my Html report. When I use the Map Esri leaflet, I'm confused by the terminology of 'feature layer URL'.... Documentation/helpThis parameter allows the user to specify a list of comma delimited ArcGIS Online feature layer URLs, that will be displayed as additional layers on the map. Is this the feature service item Id URL? or do we need to be more specific and enter the REST URL of the layer in the feature service? As I understand it leaflet provides visualization capabilities for data hosted in Feature Services, Map Services & Image services. I think the documentation needs some detailed wording and/or examples. I don't seem to have much luck using this option in the html reports, but I

Saya hendak menukar file IFC kepada geopackage. Semasa meletakan writer geopackage saya telah memilih table definition manual dan juga Automatic. Masalah yang saya hadapi pada writer yang disetting Automatic, tiada objek geometri dan pada writer yang disetting manual berlaku kegagalan…Hanya apabila memilih dinamik sahaja ianya ok. Maslah saya disini dalah tidak mahu menggunakan table definition secara dynamic. Mohon bantuan bagi yang mahir. Bersama ini disertakan file2 tersebut. Tqvm. 

Experiencing, Schema features output from the SQLExecutor only after the Data features. This is causing issues for dynamic workspace. Currently managing this by connecting FeatureHolder to the Result (Data features) port of SQLExecutor, to hold the Data features and let the Schema features reach dynamic writer first. From the above screenshot it can be noticed that, Schema features are started coming out only after the Data features. To address this, required either of the below for SQLExecutor.Schema features output first before Data features all the time.Required "Output Schema Before Data Features" parameter,  similar to SchemaScanner. FME

I am trying to think through the best way to approach this in FME. I need to create polylines from a CSV file. I have two files in the following format: File1 contains one row per line, including the start and end coordinates for all lines:Line123, StartX, StartY, EndX, EndYLine456, StartX, StartY, EndX, EndY File2 may or may not have additional midpoints. Each midpoint is on a new row. So two midpoints for Line123 would look like: Line123, X1, Y1Line123, X2, Y2 I need to combine these in the correct order to rebuild the line. For each unique LineID, I need [StartXY] + [Midpoints] + [EndXY], and the midpoints need to be in the same order as originally presented.  There are likely many ways to approach this. Here is my first attempt. I know I can use LineBuilder to construct any midpoints from the second file. It's set to wait for all inputs and process at the end, grouping b

Hi,My workspace worked in 2019.x, but I noticed an issue when it was migrated to 2022.2.0. I read in multiple *.TXT files from a single folder using a FeatureReader (passing the folder name with a parameter), they are actually csv files - so use that as the format. In the Parameters I set "Field Names Line" to None as there are none. I expose "col0,col1". It reads all the files and I get the correct feature count, but it reads the first file fine, but all subsequent files it uses the values from the first line as the field names - effectively ignoring the "Field Names Line" Parameter. Is this a bug? As I say, it worked before. Kind regards John

Hi everyone, I am looking for the right transformer to do a simple table manipulation here. So I have T1 (a table with multiple columns) and T2 (a table with a single column representing groups). I would like to duplicate T1 n number of times (n = number of groups in T2) where each row in T1 would be copied to be represented in each group to give T3 as a result.  Thanks in advance!

I have to write my results in EPSG:4099 and FME does not offer the coordinate system. I found the opportunity offered by safe to define a custom coordinate system by supplying (ESRI Projection) WKT.The resulting fme file and exception file went into my documents folder into the respective sub-directories of the FME folder.The webpage explains that by doing so every project in any installed FME version will know the coordinate system. The WKT definition for EPSG:4099 can be found here. I use the Reprojector to bring my data from EPSG:25832 to EPSG:409, write the results to file, where the writer is set to have a coordinate system of EPSG:4099. When I import the resulting dwg into QGIS the layer is recognized as EPSG:4095.When I read the resulting dwg again into FME and check the coordinate system with a CoordinateSystemExtractor then there ar

I have some datasets with unpredictable white spaces in the attribute (column) names. Is there a way to automatically trim these? The trimming tools I found all seem to be dealing with strings.

Hi all, I have two geopackage files in QGIS: One of them a multipolygon with coverage tree and the second one a multipolygon with the plots. Im looking to calculate the afforestation rate by plots, that's means the percent of total plot surface that's covered by the tree layer and add this afforestation rate as a attribute in plot layer As you see in the image below, in green I have the coverage tree and the lines show the plots limits Thanks you allPablo

There are 95207 features within the Anchors layer and 82716 features within the Candidate layer. All Candidates are exporting through the Untouched Port and nothing is coming out of the Snapped port. I have attached the workspace. Our data is projected to GDA2020 MGAZ55. Any help would be greatly appreciated. Yours sincerely. James Blythe.

Hi i have feature with 2 vertex (represent pipe line). How to built line from this 2vertex?

Please take a look on the attached files and update my workspace. It would be great if anyone highlight the process which I am missing in the simple conversion?Thanks in advance.

Hi, My workspace attached only takes information from the Website and shows values in the log. How Can I expose the response in attributes using Python caller? Thank´s

Hi,I have two polygon datasets (A and B). Of B I want to keep only the parts of the polygons which are not overlapped by A. Let's call these output features the dataset C.Additionnaly, I'd like to calculate the area of the C polygons. Ideally, I'd need to know the area of each C polygon. I've noticed that AreaCalculator seems to ouput only one single feature...Thanks in advance for your help !

Hello I need help .i would like to write the output from Fme in Esri arcsde but this sde has already domain called Base this domain include 2 coded value ,yes or not .i would like to ask ,how could I specify specific attribute in FME regarding to this domain .then when I work with this table in arcmap later ,the user get choose list (yes or no ) at this attribute (column ) .another question to get more knowledge , could I create domains for arcsde in Fme ,will be possible ?i hope if I find the answer .thanks in advance FME 2021

Hi, I'm applying a simple buffer to some polylines with the End Cap Style None and the Corner Style Arc. I was expecting to get rounded buffers on the inner vertices and none at the endpoints. However, I don't get rounded buffers on any vertice of the line, see screenshot. None of the points of my lines are treated as corners. Am I misunderstanding how this is supposed to work?

I struggle to make FME read csv files with correct encoding and datatype.I receive csv files in UTF-8 that includes non ASCII characters.FME think its win-1252 encoding and this interpret signed integer values like -27 as −27 and thus make it a character datatype. To fix the encoding i have to add the csv reader to the workbench and then change en Character encoding to UTF-8, then it works. But at that time the datatype is already set and I cannot change the varchar type column to be int32. It cause issues becasue now I cannot write to my database which expect int and not varchar...So how can I change the datatype of multiple fields after the reader has been added to the workbench? Alternatively (and better), define the CSV reader to be using UTF-8 before the CSV file has been scanned for its content   

I'm working with groups of features and I want minimize the number of blocking transformers in my workflow. Right now I'm using a Sorter to sort features in each group and a PythonCaller to make some attribute manipulation and comparison. Both transformers block the flow so  I wanted to get rid of the Sorter and do the feature sorting inside the PythonCaller but I don't see how to do it.Once I have the list of features, what should I do to sort them by one or any number of attributes? Thank you! import fmeimport fmeobjects class FeatureProcessor(object):     def __init__(self):        self.feature_list = []     def input(self, feature):        self.feature_list.append(feature)     def close(self):        pass     def process_group(self):        for feature in self.feature_list:             ## ...