Transformers

Hi. I have a spreadsheet containing stations, offsets and direction of offset (left or right). This needs to be translated to point data.How would I automate this?

Hi, I would like to merge some blob data in an attribute based on if it shares the same id, the merge also needs to happen in the correct order and I have another field with that order. Does anyone know how I would go about this. The data does not have any geometries.Thank you for your help in advance. 

Hello, my input csv is as follows (it was output from a 3 point shapefile using CoordinateExtractor):A,1,2B,3,4C,5,6I would like to output csv as follows (which will ultimately be used to generate a 3 line shapefile from LineBuilder):A_B,1,2A_B,3,4A_C,1,2A_C,5,6B_C,3,4B_C,5,6I'm trying to use various list transformers but I can't get there. Any ideas would be much appreciated!

I would like to increase the distance between groups of points, like what you see below. I have them "grouped" by common attribute so figuring out who belongs is taken care of. But I have not figured out how to get their position in relation to each other. The one in the middle is to stay put while the one on top moves up, and the one below moves down. How can I figure out which one is the "upper" and which one is the "bottomer"? This is necessary in order to move them in the right direction. I only want to move them in the Y direction. Also please note that there are 3 points in this example, but I also have some groups with only 2 members.I was thinking maybe I could use a CoordinateExtractor to get the Y values for all members in the group. But then I get stuck what to do next? My guess is that it could be solved with a TestFilter and some wizardry in the Artimetric Editor, but I don't know how.In the final step I plan to use the VertexCreator to se

I am moving data from MySQL to Oracle 12c. There is a datatype called bit on MySQL side that is not recognized by MariaDB connection. The values used in the column active are true and false.  The reader completes successfully but results show <missing>.

Hello,  I have i Workspace where i want to output some basic DGN surfaces. When the i look at the data that goes in to DGN writer they are of the type "fme_surface". But when i open the new its the same shape but build of a lot of fme_lines.  Before Writer: After writer: Is there some setting in the writer that i might have missed that can cause this problem?

Hi, Is there a simple way to wrap a single quote mark in a string for the SQL Executor? Occasionally we will have a name that contains a single quote i.e St Paul's and these are being passed in as parameters into a executor for a Postgres database. thanks

I would like to try the following:Identify where lines touch and set an unique id to these overlapping/touching vertice (as in points, I hope I get the lingo right here).I will then move one of the lines with an OffsetCurveGenerator. Which means that the two lines wont be touching any more.Finally I would like to use the identifiers at the end of both lines as pairs and create a new line between the two.Q: How can I set a unique identifier to a vertice, similar to using a counter to set a id to the whole feature?Or is there a much simpler way to get the result I want? 

So I'm trying to get the max and min of a row of data across all attributes (all number attributes).I used the list builder and got all the attributes into a list, except it is like this _list{}.col1, _list{}.col2, etcThere are 54 attributes so I'm not sure how to combine all the parts together to get the min and max. I can't use listSorter as it is asking me to pick _list{}.col1..._list{}.col55 when I want to sort _list{}. Is this a nested list? is there to flatten it it maybe?Maybe there's a better way to go? Would appreciate some help. Thanks

Dear reader, I'm trying to simplify a polyline. The image below shows the area's which I would like to transform in such a way that it becomes the shortest line. (Instead of these unwanted protusions). First I used an anchoredsnapper to create the line resulating in the image below. Using different snapping distances creates (unwanted) prostusions on different locations. In trying to solve this problem I used different generalizers (SherbendGeneralizer and the regular Generalizer). However, that did not help. Could anybody suggest a different approach? Thanks in advance,  Adriaan. 

Hi,I know FeatureHolder waiting for all previous results to come in but how do we handle a situation where two previous steps are "Either/Or" relation? As long as one line came to FeatureHolder, it should proceed, how do I deal with this situation? Thanks .

I have an older FME Workspace (this it was originally done in a 2018 version) and I opened it using 2019.1, pointed the readers to a new spreadsheet and the statistics calculator is yielding different results than before. I'm trying to get a continuous count based on an attribute. Examples of the results from 2018 that I'm trying to get with 2019 are below. Based on the change log for that transformer, I'm interpreting that what I'm trying to achieve is not supported by this transformer anymore. Any help would be appreciated. 2018 ResultsAttributeCountA1B1B2B3C1C2C3C4D1 2019 ResultsAttributeCountA1B3B3B3C4C4C4C4D1

i have points for each gas stations on both side of highways and shape file of highways road network..i want to caclulate the distance between gas stations on each side .. and side of gas station

I have the following issue. When trying to assign % symbol to attribute, the output is empty field. How can it be solved?

I have run into the strangest problem using the Intersector. Source A is a dataset of overlaying polylines containing attributes I want transferred to the polylines in source C. B is a polygon I use to reduce the amount of data whilst building the workspace, B is to be deleted in the final version. As long as the data passes the clipper the output is as expected, ie features are cut and attributes are merged. But when I bypass the clipper (and turn it off) the data gets cut but attributes are not merged.What on earth is going on here? I can't make sense of this.

Hello,Is there a way to create sampling hexagon using fme (and python caller) that would cover a study area?Basically, the idea is to create a mesh of sample hexagons and ensure that that all regions within the study area are represented by the sampling results as you can see in this post?Thanks

I know this has been asked many times, but i cannot get it to work.  My data is: ObjectCategoryNumApple8091Apple 81122Apple8100Banana80913Banana81014Banana81155 And i want to turn it into Object809810811Apple1022Banana131455 I've tried to do the method i've read on the forums using attributecreator, however, its not creating multiple columns based on the column names. ie, in AttributeCreator:NewAttribute: @Value(Category)AttributeValue: @Value(Num)doesnt do anything.  I am using FME 2019.   

Hi,Have a file with lines of 10 meters each, each with its own rotation.Want to move every line.The midpoint must be moved to the end point.The length, rotation and Z must not changeHow do you do that?

The USGS have deprecated their earthquake feed in GeoRSS and replaced it with a GeoJSON. No problem I thought, in fact better - but wait.  The timestamp of the earthquake is now provided as a long integer in milliseconds from the Epoch. Milliseconds? I can see the intent, but the usual standard is whole seconds, and only whole seconds are  supported in the DateFormatter.  The trouble is that I cannot divide the time by 1000 for the DateFormatter because it is a 64 bit long and it seems that 32bit FME cannot handle it.  I have tried to treat it as a string, but that does not work either. Maybe a PythonCaller, but can I pass it across?  Here is the feed URI http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_month.geojson

Hi everyone,I have a very basic (I guess) issue that I can't deal with nor find an appropriate tutorial or answer on the web... I have a 1 band Geotiff that comes from a substraction between two Digital Elevation Models (bathymetric survey). I manage to give a value to nodata (RasterBandNodataSetter) and remove the nodata identifier (RasterBandNodataRemover). So the Geotiff I'm working with as no nodata.I want to associate color (chosen or by default) to different ranges of value, just for visualization of the result. I can do it with any GIS software (like ArcGIS) but couldn't manage to do it with FME. I tried to connect a RasterPaletteGenerator to the Geotiff Reader but I get a translation terminated with the rejection code 'INVALID_RASTER_BAND'. As I have no idea of the problem and where to start to manipulate palette and raster band, any help or links to tutorial or web pages would be greatly appreciated.Please find attached the Geotiff I'm talking about.Tha

I have a set of polygons with OwnerID and a set of polygons without OwnerID. On another layer, I have connection lines. I am trying to give OwnerID attribute to linked polygons using the endpoint of lines to link them together.LineOnAreaOverlayer is good for 90% of the cases but some polygons are traversed by the lines and sould not be considered.here is sample, green polygons has an OwnerID, white polygons don'tUsually, I have only two (2) polygons to link together, but sometimes there is multiple polygons to chain link together. Any Idea ?Thank you

Hi!I have some 3D faces that have been saved out to a FFS. Now I'm trying to use a Search envelope on a FFS reader to load the model above, I want to clip the model according to the bound. It works but many(all) of the clipped faces have faulty values at Z=0. I would expect to get a nice clean cut on the 3D-faces, with correct z-height at all their indices. See this image:  I have attached the soure files for debugging. Is this a known bug? Any workaround available?

I load files into a PostGIS DB. When I get new files that update certain areas, I'd like to do change detection. I've tried a bunch of different ways to try to compare the file to the data already in the DB. Is there a trick to this? Seems everything I try give either all new or updated. I know that there is mostly the same polies with very few updates. Is there a trick if the datasources are DB against file? Any help greatly appreciated.

I am using AttributeExposer (AE) and need to import the values from a table. I do not know how many values there are before I run the workspace, so I need to be able to import the values from a table created by the workspace.I thought I had it all worked out and then realized that the "Import..." option might not be "live." i.e., it worked the one time and has been holding onto the values I entered, rather than repopulating with a newly created table each time.Is this true? Is this "one and done" and you need to manually reload these values if the table you loaded them from changes?I need to do this after I use AttributeCreator, because the attributes that are created are invisible. If there was way to create attributes and have them be visible, that would be wonderful.Thank you,Randy McGregor

I want to summarized the polygons (see picture) to bigger polygons.The polygons should be summarized by their number in the middle to around 1000 (+- 100).At the End there are a lot of polygons with a number around 1000.