Transformers

I have an input shapefile with many features that overlap between them. I need to create a new shapefile with many features as well, derived from this input shapefile, but without overlap features. For this, I need that the overlap features is converted to just one feature considering filtering by attributes of the overlap features. These attributes are related to the date inserted in a field, but should also be extracted accordingly . I mean, I need to extract a feature in overlap areas considering this order of priority (see path field): 201705, 201704.. ; if not exist, use 201807, 201805, 201806, If there are attributes equal (same month and year), use the most recent. An easy example in attachment to explain this better, Features of final shapefile should be merged if adjacent features are equal. IN the example final shapefile should have 3 features without overlap areas

Good morning,I am trying to come up with a way to generate lines where the starting locations are contained in one data set and the end points are contained in another data set. I have 19 "start" points and 4 "end" points; I need a line from each start point to each end point - So I should end up with 76 lines. Any guidance on how I should accomplish this would be greatly appreciated. I've been toying around with lists and trying to loop through them to create all the pairs of points that I need to feed into the LineBuilder, but I've been struggling with how to get it done. Thanks,Brian

Hello, I have a workspace that joins measures from lines to points using a neighborfinder, pointonlineoverlyer and measureextractor. The purpose of this is to identify the linear reference of each point along a line (ie distance along a line).Rather than do this separately for each point, is here a way of using a point cloud to append the measure for each point in one go and speed things up?Even though the points are in 3d im just interested in the perpendicular/plan reference.Thanks,Owen

Hi,I'm trying to convert 3D faces / meshes from DWG to Collada meshes to be used in 3D Studio Max. Moving data closer to origo with offsetter and 3D affiner both seem to work, but not quite. In collada all vertices reside in original coordinate system space (EPSG:3878) and only transformation matrix is being moved. Perfect situation would be that transformation matrices would be normalized to 0...1 space and each vertice would be near origo (few thousand units distance). Transformation matrices look like this in inspector; | 1 0 0 -24000000 || 0 1 0 -6800000 || 0 0 1 0 || 0 0 0 1 | and in collada;<node> <matrix>1 0 0 -24000000 0 1 0 -6800000 0 0 1 0 0.0 0.0 0.0 1.0</matrix> I'd guess normalizing transformation matrix to 0...1 range would solve this issue. Which translator is able to do that in FME? 

Hi there,I use Python caller to run Python script in FME. Python caller reads the data and generates a new data frame (with more attributes) after performing calculations. Now I want to output the new data frame and do not display the old data (that is feeding as input to Python Caller). I am not sure how to do that. Any help would be really appreciated.

Hi,I am using FME 2019.1 and have encountered a strange issue with the Counter transformer.I am getting the below value being returned in the _count attribute for some but not all records. Just prior to the Counter transformer I reversed the orientation of a few records and I have found that for those records which are reversed, I get the below value output, but for those which are not reversed, I get a normal number output. However, when I pass only the reversed records through the counter, I get normal number outputs. It doesn't seem to like the combination of reversed and non-reversed records!@Value(__fme_ft_return_value112f8e69-4aa4-4f5f-9f81-f47c60797f64)Has anyone seen this before?

How would i use the RasterBandMinMaxExtractor to get the absolute min and max of multiple rasters? i see it writes it back to the raster, but I should already have this value, i think. It shows with gdal. I'm trying to normalize multiple rasters for subtraction and am very new to FME.

Hi there, I got crime data along with the date field. Now I want to calculate the Monthly average of crime data. For instance, Crime data for Janaury 2018, January 2019, and so on. Could anyone guide me how to do in FME?

I need to create a workspace that I can use to find groups (brands) that are wrong or do not fit with the majority of what is in my existing shapefile. For example: If 1000 Boston Pizza have group of 'Boston Pizza' and 5 have a group of 'Boston Pizza Restaurant and Bar' - then the logic should replace those 5 with the majority group.

I am trying to write to an Inspire GML writer using the Habitats and Biotopes xsd but I am not getting any geometry. If I preview the output from the last transformer I can see that the geometry is polygons:But the written GML just contains the attributes and no geometry.Does anyone have any clue what I am doing wrong?

Hi folks,This seems like a fairly simple operation, but for the life of me I can't seem to figure it out. All I need to do is move an existing excel file from one folder to a subfolder. (A subsequent workbench will run, regenerating a new excel spreadsheet in the original location.)I've read a few of the other answers, but none seem to have what I'm looking for. A few of them mention a 'Move' parameter in the filecopy transformer, but the only writer parameters available to me are 'Overwrite existing file' with options being 'yes' or 'no'. (Upon further investigation, the 'Move' parameter only becomes available as an option when file type 'FileCopy' is selected. If i select MS Excel as the filetype, then the 'Move' option is no longer available. Any ideas?

Hi there, I am trying to calculate the four date fields related to the start and end of the current and previous regulatory year based on the current date. The regulatory year starts from 1st of April and ends on 31 March of next year. So in this way current regulatory year starts from 1st April 2019 and ends on 31 March 2020. Here is my logic :Current_regulatory_year_start: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P9M),%Y%m)01,%Y%m%d)Current_regulatory_year_end: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),P2M),%Y%m)31,%Y%m%d)Previous-regulatory_year_start: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P21M),%Y%m)01,%Y%m%d)Previous_regulatory_year_end: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P10M),%Y%m)31,%Y%m%d) However, it does not produce the desired result. Current_reulatory_year_end and previous_regulatory_year_end produce null value, whereas the oth

I am working on a workspace that receives a list of previously unknown attributes and their values. They come as a list of attributes: '_list{}.Property' and '_list{}.Value'. These sets need to become GeometryTraits on an FMENull geometry. Usually I would use a GeometryPropertySetter to create those traits, but since it is unknown upfront how many features these lists contain, I want to use a PythonCaller to loop through the list and set the traits.  I seem neither to be able to create an FMENull feature, nor to set it's geometry name or traits. Can anyone help me with a working code snippit?

I have two data sets, one is a point with XYZ and RPY values. The other is a polygonal sphere. I want to rotate the sphere around the point's values with the 3D Rotator, but the workspace keeps throwing the following error: ERROR |3DRotator: Unable to convert @Affine parameter B value `' to a floating point value. What is the cause of this? The data itself is as far as I can see correct, and when I use a point instead of the polygon sphere, I get no error.

Hi all,  I have a question. Is it possible to have more than one schema location(*.xsd) in "XMLValidator"? Does XMLValidator supports multi schema location paths?  Best regards, Mani

i want to ask about my issue: in my map,i have many lines and many blocks and i want to say ,if the line has red colour touched the block so any line get out of this block will take deifferent colour and get new idFirst ,what i understood i have to use lineonAreaOverlayer transformer to find which line intersected with blocksbut how can i put a condition if any red line that include base id touched the block so any lines get out of this block will get different colours and each line will have new Id   Thanks     

I have old workspace and received the following Python error message after upgraded to FME 2019.2 and didn't install any Python 2.x. Any suggestion for getting around the issue ? Thanks.Python Exception <NameError>: name 'unicode' is not definedTraceback (most recent call last): File "<string>", line 26, in inputNameError: name 'unicode' is not definedError encountered while calling method `input'DateTimeCalculator_2_PythonCaller (PythonFactory): PythonFactory failed to process featureA fatal error has occurred. Check the logfile above for details

Good morning,I am trying to extend lines till they intersect. I have a gap between three lines (see attached picture). I would like to extend each line using each lines same trajectory until they all intersect. Is there a way to do this programmatically? Instead of specifying a certain distance to extend the lines. So I want to find the next point along the line on the same trajectory. I have tried using the distance formula, but I get the shortest distance to each point, but that gives me a triangle instead of T intersection.Any guidance would be greatly appreciated! Thanks!David

I need the following:Every line has to have two numbers, the rest will be the same.  Is there a simple way to do this?With kind regards Remco

Hi all,  I have something weird going on in my StringReplacer.E.g. a simple string goes in. StringReplacer settings: RegEx captures whole string in capture group 1, then as a replacement I use capture group 1, followed by the string "finished"  In the output the string "finished" is somehow duplicated. Magic / bug / am I doing something wrong? Cheers, Ed 

i have data like belowi need output like belowNote: calculate percentage in percentage field with comparing name and name ID fields.

Hello all, I want to generate a vector point from the origin point of a raster.My raster is an ecw (version 2) format.I can expose the coordinate values of the origin point by using RasterPropertyExtractorBut, I fail to create the vector point with VertexCreator. I assume this is because the raster still exists and I cannot add a vector point to a raster feature. If I could replace the raster with the vector point, this would work for me.

I have a workspace that creates an ESRIJSON file of features. The problem is I have 90 to upload but any more than 2 features causes a http 414 uri too long return from the destination server with a POST request. Any ideas on how to send 1 feature at a time? I tried WorkspaceRunner which processes one at a time but I need to write the json file from the incoming feature each time and I can't figure that out as yet.  

How can i convert date from dd.mm.yy to yyyy (4 digit only ) in column in excel as example 01.02.2000 to 2000 only Thanks

i want to show filter on the header of column and change size of line and do the words inside cell in the center and each celll has size 50 .i mean rrange the cell and show fiolter that exactly what i needif it is not possible to apply filter in the output ,at least my input excel has filter on header ,i want to keep the filter as input i mean do no action on it .thanks