Transformers

HiI need to find and extract from column B the value present in column A for first record for ex PACHINO any suggestion ? Thx Francesco

Hi all, I have a GPS trajectory and I would like to select the lines (roads) close to GPS point. I am using NeigborFinder to do that. However, all lines are getting matched even though as you can see in the images I have roads that should be not selected . When NeigborFinder finds a closest lines to a point, does it not find the same line as closest line to consecutive point? How can I solve this problem? Thanks in advance.   

After upgrading FME Desktop 64-bit on Windows 10 to the latest version 2019.0.1 build 19253, FME Data Inspector became not to handle any 3D geometries.If a workspace contains an Inspector and you send 3D features to it, Data Inspecector once opens but then closes automatically without displaying the translation result. If the Visual Preview was active, Workbench would close silently after the translation finished.Reinstalled FME 2019.0.1 twice, but the symptom still appears.Have you observed such a symptom?

Hello!I try to send the message in html formatted view. But I can do it without attached files only. I don't receive any notifications from the server if I try to send a notification with an attachment. Do you have any ideas where is the problem?Many thanks beforehand.

how to read rows aqs list instead of columns?

Is there a way to increase the number of significant digits in the world file on the tif writer?  I have a large imagery dataset with a native resolution of 2.9456395e-6.When tiling them as set of tif+tfw (required for 3rd party software) the tfw is written as 0.0000029456.This truncation leads to minor offsets in the tiled images and every 340000 pixels or so, the cumulative offset is a full pixel, leading to black lines when the adjoining tiles are mosaiked.  

Hello,I'm struggling with making a certain module: I have 2 3D points with a certain z-value and i have a 2D arc "connecting" them.I am now trying to build a module which would make a 3D arc or a generalized 3D polyline using the z values of the 2 points given.At this point I'm just doing this manually but an automatisation of this process would certainly increase my workflow.Can someone just point me in the right direction so I could solve this.Thanks, EDIT: The two 3D points do indeed have a different value in Z.

I'm able to geocode all my addresses using the Geocode transformer and either the ArcGIS Online or OpenCage services. However if I trying using our internal ArcGIS Server REST service, all my addresses are rejected. I've tested the REST services manually and with ArcGIS Desktop, and it works as expected. Can anyone shed some light on what the problem may be combined with this transformer?

Hello,I have a dataset Example:NameFirstnameAddressConcattedStringMichaelsJohnFirststreet 5Michaels_John_Firststreet 5MichaelsJonFirststreet 5Michaels_Jon_Firststreet 5MychaelJohnFirtstreet 5Mychael_John_Firtstreet 5 "ConcattedString" is a field I generated with AttributeCreator because I think it's easier to find duplicates.I don't want to remove them just want to show possible candidates as a "group".I experimented with FuzzyDuplicateRemover, Matcher, ... with no luck.Read the https://knowledge.safe.com/articles/53183/data-qa-identifying-duplicate-attribute-values.html, but I can't figure it out.Is it even possible? If yes, can someone give me a little push in the right direction? :-)Using FME 2019 build 19253 TIA -Jonathan

Hi, I would like to detect lines, with the same attribute name - ID, that are not connected (they are splited but it shouldnt be so). Any suggestions?

HI, I need to get a sum of attributes.For Example: Gew: 45Priv: 388 I need to get : Result 433 Which transformer to use?

I have features with about 15 string attributes. Each of these attributes has to be split into a list in order to delete duplicate values. I have already used an AttributeSplitter followed by a ListDuplicateRemover. But since I have 15 attributes, I was wondering if there is a more effective way of doing this instead of having 15 AttributeSplitters and 15 ListDuplicateRemovers.Thank you!

I have some geometric data and I set its coordinate system to *XY-FT* and I verified it was correctly changed using the data inspector. I am writing this data on the ArcGis Online Plateform and I set the coordinate system to *XY-FT* again in the transformer parameters. When I view the written data, the coordinate system is not the one I chose but the SPHERICAL_MERCATOR. How can I solve this problem?

Hi, I recently started working for a company that focuses on utilities in northeastern Massachusetts. My duties are to create FME desktop models of data provided from field crews. I have only been there for two weeks but I am having trouble of understanding how to build models without using a list that FME basic desktop uses for tutorials. How do I get better at creating FME models being provided of a list of how to do it?

I would like to connect points without taking their order into account but instead their closeness.Basically, I tried to build a line with all trhe points and then looked for the shortest path finder.The algorithm seems corrects. However, It taking too much time when it has hundred of points to be treated.Any ideas on how to improve the efficiency of the shortestpathfinder in this case? 

Can SQLCreator/SQLExecutor create columns and alter values. I've completed all the left join I require and now wanting to create a new column with calculated values.Duplicate an existing column with new name / Select existingTable.existingColumn as newColumnCan I use if-then statements / If existingTable.existingValue = 'DI' then newColumn = '1234'

I'm trying to remove the hidden attributes fme_geometry and fme_type from the MSQQL_ADO reader before using the AttributeExploder, so that these attributes want be transposed, in order to speed up the process. If these attributes are exploded, I need a testfilter afterwards to remove these values. I've tried to expose the fme_gemetry and fme_type and then tried an AttributeRemover and BulkAttributeRemover to remove this values, without success. I was able to remove the default multi_* attributes with the BulkAttributeRemover, but not fme_attributes. Is there anyway to remove fme_geometry or fme_type. Thanks in advanced/Jonas

I have 2 shape files: firesmart and forest area. I want to clip firesmart according to forest area. The workspace fmw script do the clip and generate shape file and SDE feature class. The generated shape file are in the correct location, however, SDE feature class has shifted to a different location. What's the reason and how to solve it?

Hello everyone, I have a little problem. I have multiple and partially overlapping geotiffs and I have to clip some parts from every raster using multiple Polygon-Features. They are "connected" by one attribute, e.g. the raster is called xyz.tif and the clipper-polygons have this name as an attribute. The Polygon-Shapefile has a lot of different features. How can i group them, so that every raster is only clipped by the belonging Polygon-Features???I thought, it would be the "Group-By" argument in Clipper Transformer, but it's not working this way. Because of the overlapping I can't ignore the Pairing Raster <-> Polygons.Any idea please?   

Hello all,I am trying to create a HTML Report that has a table plus also a map image.The problem I am finding is that the Report is being created before the image is finished and then ends up with the image of the previous job.I have tried connecting the feature writer into the report generator, which works but I end up with an extra row in the table with a "none" record.Is there a way to force the image to be created before the report? 

Hi there,I have a workspace that is using the SystemCaller to run an encryption/decryption process (GnuPG ). It runs fine from Desktop and Server when I set the FME Server Engines to use my Admin account, but when I set the Server Engines to use a service account (and I'm logged into that account), FME Desktop runs fine but Server fails to execute. I think I've narrowed it down to the fact that I need to force the Command Prompt to run as Admin from FME, but I'm not sure of how to do that. Any ideas?Thanks!Sam

I have a file geodatabase that contains several feature datasets.Here is what I need to do......The AnswerAll point feature contains over 5000 rows, however I need to "select by attributes" using Comp_Name.......this yields me 376 results each with a varying number of rows for each Comp_Name.I then need to take the HCA Name from each of these rows and find the corresponding HCA polygon in my HCA's dataset.Once I have the HCA Names and there associated polygons for each Comp_Name, I need to create a Bounding Box Polygon around those Polygons, and export it out with the Comp_Name, HCANames, and HCATypesI can attach my geodatabase if anyone wants to take a crack at this!

where can i find what exloded attributes mean?

Hello there, I have a question regarding the AreaOnAreaOverlayer. When I use that transformer to clean my polygons I get some polygons with really sharp edges. Is there a way to avoid this? I guess it is random on how it decides which polygon to cut from another polygon when they overlap, right? Thanks very much in advance for your help!

Recently it occured to me, that I have to solve a set of seemingly similar control flow problems in FME quite often.Starting point is a workspace which is re-used for different scenarios. A generic approach to solve a family of similar tasks.Basic problem usually is the behaviour of transformers like Clipper, AppearanceSetter, and similar ones which need two (or more) different streams of features and produce a result which combines the data sets.Clippers clip Clippees, Geometry is textured with rasterdata, ... you get the ideaProblem starts whenever one of the necessary datasets is missing.E.g. the result stream of a processing may need clipping and goes into the Clippee port of the Clipper. If there are no Clippers available no output is produced.So as a workaround I need to fumble around with a FeatureMerger and several helper transformers to let the resulting stream pass by the Clipper whenever there happens to be no clipping feature.Or I need to avoid the AppearanceSetter if eithe