Transformers

Hello,I would like to compare two attributes of the same table: e.g. a table of features with the following attributes: UID, old name, new name.I would like to know for which features the old name is the same as the new name and identify the features whose name has changed. Afterwards I would like to create new tables for all (and only) these features whose name has changed, one with the UID and the old name and one with the UID and the new name.Which transformers should I use ?Thanks for you help!

Hello!  After trying different options with LineExtender, Snipper, PointonAreaOverlayer, I don't get the result I want. What I want: to be able to extend a line with an attribute. However, this value is different for each side of the line. Vertices on each side of the line contain this information for the particular side.  How do I get this to work?  Thanks a lot!!!  Stay safe!

Hi,  I noticed the following behavior.I created two shapefiles for this test : line.shp and surface.shpBoth contain several feature including one with multiparts (multiline and multisurface). When using CoordinateExtractor with mode Specify Coordinate + index=0, I get in the _x and _y attributes the first point of the first part of line/surface.I assumed I would get the same with @XValue() and @YValue() but it is not the case for the multiparts features.For those I get a point far far away from the feature, with integer values for X and Y. Anybody knows why ? Is it a normal behavior ? Tested on FME 2018.1 and 2019.0, see enclosed test workspace on FME 2019.

I am looking to change the RouteName column (incoming website data) from - to _ format using FME workbench 2019 2.3.1 . What transformer would complete this task? would StringFormatter work?

hey i am trying to do a 2D grid that is originated on the same angle of a line as an input feature,while i could do distance chopper on the line and an oriented boundary box, this doesn't give me the control i require to maintain the same polygon size. the 2D grid creater allows me to define the cell size within the grid but doesn't allow me to orientate it to the input featuremaybe i could do a start point, end point of the input feature, then draw a line, get the angle and rotate the grid? the challenge with this approach is that the line is not straight, so the grid needs to follow the line and not just the start and end pointsany advise would be grandmany thanksJames

 Hello Community, My goal is to find parallel lines (green) and the dots (5 points) of line (1). Line 1 and A,B,C and D belong to the same type in my dataset. A,B,C and D are almost at an angle of 90 degrees of line 1, sometimes it can even be 45 degrees; it's variable. If I use a bufferer all blue lines are processed. How can I exclude the A,B,C and D lines from processing?Greetings.

Hello, I'm looking for an alternative to the ArcGIS command "Spatial Join" in FME. Important for me is the matching option "WITHIN_A_DISTANCE_3D".My goal is to determine the number of neighboring points in a space from each point of a point cloud (and write it into an attribute of the point. In ArcGIS I would use the following command arcpy.SpatialJoin_analysis("powerline_01", "powerline_01", "e:\LAS\powerline_10m_DIST.shp", "JOIN_ONE_TO_ONE", "KEEP_ALL",""", "WITHIN_A_DISTANCE_3D", "10 Meters", "DIST_10m")Unfortunately, I have found only similar transformers in FME, which do not work in space, but only 2D. For me it is not interesting which point is closest to the origin, but the number of points within a space. Thanks a lot for any advise

Hi, I´m currently setting up a custom Python interpreter for FME Server 2020.0I have installed a custom Pyhon installation and added a packge to it. I´ve also runned the following commands with administrator privileges in command prompt:"C:/Program Files/FMEServer/Server/fme/fme.exe" APPLY_SETTINGS SYSTEM "Python/Use Custom Python" true"C:/Program Files/FMEServer/Server/fme/fme.exe" APPLY_SETTINGS SYSTEM "Python/Python Interpreter" "path_to_pyhon_folder/python37.dll"When I run my workspace that uses Python I get:The PYTHONHOME for the user-specified Python interpreter is not set through FME Options or a PYTHONHOME environment variable. On my local computer I can set the PYTHONHOME-parameter under Tools-FME Options...But what is the command to set this parameter on FME-Server?The documention only covers the two commands I've already runed.

Hello, I have an XML file (consists of 300+ entities) that I wish to insert to Azure SQL, thus creating 300+ tables. When inserting data to Azure (contrary to SQL Server) you must specify a primary key or a clustered index. I know this type of functionality is feasible by changing the attributes of the Writer at the Index column. However, doing this for 300+ tables manually, is not sustainable. Dynamic writer was not able to assist either. My other thought is to read as merged dataset, create a uuid and then using SQL Executor assign this attribute as a clustered index in every table? In this case, will the Writer be able to pick up this automatically? Other suggestions are much appreciated. Kind regards, George

I'm trying to read in JSON file. It has ANSI encoding. The reader throws an error:"A JSON syntax error was found at line 1, column 49. A sequence of bytes was found which is invalid in the UTF-8 encoding."Is it possible to get around this?

Hello everyone.I work with sewer programs, and found that working with NetworkFlowOrientor can be very helpful in ongoing work.The purpose for which I use NetworkFlowOrientor is to find mistakes made during autocad typing.As we know, sewage flows gravitationally so it is important that the beginning of the line be in the high sewer pit and the end point will be in the low sewer pit.When I work with NetworkFlowOrientor I put the sewer line in line port, And in destination the layer of sewer pits.When I check the result coming out in GIS, most of the lines that needed to be flipped were flipped.But about 20% reversed incorrectly.I guess the problem is in my file, I guess in the sewer pits layer.So I would like to understand the nature of the NetworkFlowOrientor well.And here's a small example of him turning the line the wrong way.The arrow indicates the flow direction, here in the original file. (Red is the end of the line)And in the picture here the line flipped over to me, even th

Hi All,Not to be hyperspecific but i'm trying to match phase values between two attributes on the same feature. I have an electric transformer with a phase value, and I've joined the phase value of it's connected electric cable to the same feature. The phase values can be any combination of A,B, or C. For example, the electric transformer might have a value of AC, and the cable it's joined to has a value of ABC. I'm trying to find a way to test if the phase values of the transformer are contained within the phase values of the cable. I've tried setting up a tester and matching XFMRPhase - IN - PrimaryPhase, the inverse of that. I've tried removing the commas and testing the same. I've tried testing XFMRPhase - LIKE - PrimaryPhase and I keep finding results that don't match. For example, i'll find a transformer with phasing ABC, primary cable with phasing ABC as unmatched. I'm not sure what the best way to tackle this would be, but a nudge in

How can I call a workspace x number of times (multiple times) to compare with actual output by using the python script do you have any git hub help links

Hello, I have made corrections to a Dwg file, except that in the output Writer, my lines have disappeared, it no longer appears in the output Dwg file. All other block type entities are displayed except the line type entities. However the missing lines belonging to the layer EP_GEOREF_SOUT_GAINE_PLEINE (190 entities) appear well in the transfer but it does not appear in the output dwg.  Do you have a solution or the parameter which makes it possible to display the lines in the Dwg in output writer?  thank you in advance

Good evening,  I have two shapefiles, which I want to merge with each other and then continue working with the partial results. One shapefile contains the boundaries of the municipalities and the other shapefile contains the BoundaryBoxes of the LAS tiles. Since the amount of data is too large, I want to process the data community by community.The tiles marked in blue contain the names and paths of the individual LAS tiles in an attribute [ID]. In my Workbench I perform a spatial selection using the SpatialRelator. For this I connected the shapefile with the information of the LAS tiles to the supplier port and connected the community boundaries to the requester port. .As a result, I get a list of all elements that contain the community (like the tiles marked blue in the first picture). To check if the selection is correct, I exploded the list with the Listexploder. The result is correct and so far everything is clear.Next, I want to read the 22 selected tiles, which are stored in the

Hello,We have set up an in-house Nominatim OpenStreetMap geocoder service and we would really like to use it with FME to geocode 100k+ addresses. The problem I'm having is the data is split up into "Street" "city" "Zip" etc and it would be a difficult additional task to constantly be concatenating them. For some reason the Geocoder is only allowing for Street Address in the Transformer. Is there a way to get this to recognize multiple address fields. Thanks!  

Hi all  I'm about to make a spatial query from two tables. One is a SQL-Creater with a MSSQL Spatial driver. The other is a WFS with polygons. (I have to read from MSSQL by SQLCreater because of a complex nested query that won't fit into the MSSQLSpatial Reader. I've tested the query in MSSQL Server Management Studio and it works just fine with geometry attached).  I've loaded the PointOnAreaOverlayer, however it doesn't seem to fetch the GEOMETRI-column in which the geographic data is.  Is it a setting in the SQLCreater or in the POAO that has to be made for it in order to make a spatial join?  

Hello FME community!I am working on a project to identify traffic congestion within our mining operations. My data source includes GPS points of all vehicles and I have done the work to 'connect the dots' of all GPS points to create speed segments. As you can see in the image below, I now have traffic routes for each individual vehicle.What I am trying to do now is create a "Median Line" for each side of the road, by determining the median value for the segments within a certain distance (i.e. 100m), just like the Traffic layer in Google Maps. My thoughts are to use a "Line Splitter" to split each segment into 100m parts, and then "Nearest Neighbor Aggregator", followed by a "List Exploder", then an aggregator to calculate the median.Input: Desired output:Any suggestions here would be awesome!Thank you!

Hi all,What's the best way of getting FME to populate an attribute field in ArcGIS geodatabase point feature class A (areas of interest) with the total count of features from dataset B (assets)? I.e. find the total number of assets within 10m distance of sites?I thought the Neighbourhood Finder or Point on Point transformers followed by a Statistics Calculator should do the trick, but can't get it to work.Thank you!

Hi, I am trying to convert 12Dxml string data to other datasets but really struggling with the way the geometries are being read by the 12Dxml reader.I am not trying to do anything fancy just read the file. from 12Da file  from FME

Hello everyoneI am new using FME Workbench and I am having some difficulties. My problem it is related to LAS dataset. I have two lasdatasets from differents providers, the first one is Spanish Geographic Institute and the second one was generated from Agisoft photoscan after processing Drone made ortophotography. I have convertedboth into the same coordintate system, concretely, ETRS89 (the legal one in Spain) and when I trate to fuse both clouds using aggregator, x and y points fix perfectly but Z values has a difference of 50,96 m. I applied too 3D forcer and Offsetter but the results are the same. How I must to proceed in order to fuse both Las dataset without the 50.96m difference in Z field?Thank you very much!

i would like to ask ,after i read my data from reader .i have around 8 reader and i would like the first reader that reads polygon to start processing through some transformers and stop when it reachs clipperbut i found after it reads the data ,it did not pass through the first transformer and the workspace continues reading the data from another readers and after all readers finish ,it comes bk to continue work on this reader for polygon .what i would like exactly,i need to extract the data from the first reader and continues till it reaches clipper and wait another data .because,i think that clipper is working at end of my workspace so it takes too much time to process . i read some articles about runtime order but i think it is only working for creators that has no input if i understood correct but if i have transformer with input .How could i let this transformer work before another path .as featuremerger and clipperi hope , i can get solution for my problem .i have another questio

Hello, Would you be how to merge the linear array of a Dwg file to form a single polyline. I had thought of NetworkTopologyCalculator I do not know what you think? After having combined (merge) the linear network all together, I have to put it in the same direction and after that I cut it at the points that belong to the layers of my Dwg file that I specify. I would tend to use Linecombiner or LineExtender. If you have an idea of how to proceed I am a taker? In all thank you in advance for your help.

Hello, is it possible that someone share with me the knowledge how DecimalDegreesCalculator transformer exactly is calculating the decimal degrees from Degrees Minutes Seconds (DMS)? Is this the formula for it? Decimal Deg = Deg + Min / 60 + sec / 3600

Hi All,I am trying to split the attribute in the text string, which has old and new attributes with same id and then make selection for specific attributes like surface ,highway. Final action is to create the column for each split attribute . Attribute listed in the text string are different every time and not in sequence so i am not sure how i can create columns dynamically. screenshot of the input dataTried solutions : I have tried to do this using the attribute splitter and list expolder and then extracting attribute per columns but now i am getting too many columns for each id.can somebody suggest ?