Transformers

Hi,I try to increment a field start at 1 and finish at the end of the file. I use a counter and it's work fin with 1 file. But i have 38 file. I need to start at 1 for each file. Do you have any suggestion? Thanks

Hello,I am looking to combine two time fields to create a new column output. I've tested a lot of functions and time formats but can't seem to get it right so maybe someone in the FME Community can help.  My first field is a specific time of day (departure_time), and I would like to add a second time field (travel_time) to achieve a final column with arrival_time.departure_time and travel_time were originally in %H:%M:%S, will I need to convert these formats prior to a calculator? is calculation between two time fields even possible?Any help would be much appreciated!

Hi all,I have street centerline dataset, In the datasets, there are some lines that smaller than 80 feet. I would like to combine those small lines with adjacent centerline. However, I could not find a way how i can use line combiner based on such condition.The line in the image is 70 feet so i would like to combine it either the lines behind or ahead.  Any idea? Thanks in advance. Best,

I'm trying out FME Desktop as a possible solution for some data manipulation for our company. I've started watching some demos and tutorials, but the going is slow for information related to what I'm trying. Is there any way to get a proof of concept from Safe to evaluate how well it works for us before purchasing the software? I don't want to spend too long on this only to find it doesn't do what we want as I have other IT responsibilities and don't know that I'll be able to tackle this test project before the trial period is over. Is this a question for sales? Thanks!

Hi,I have two point feature classes and I need to create line or line feature class using first record in the first feature class with first record in the second feature class and so on. First Feature class Point -- First Feature class pointFirst Feature Class Point - Second Feature class pointFirst Feature class Point- third feature class point....Second Feature Point - first feature class point  Cheers,Srikanth Dasari

Does anyone know if its possible to encrypt and de-crpyt strings in FME. So if I needed to encrypt an email address to save it to a database and decrpyt it to send email out at a later date. Is that possible?Thanks

I have a polygon dataset.90% of this dataset is polygons composed of lines10% of this dataset is polygons composed of lines+arcs.How to I filter out the 10% lines+arcs records while keeping the geometry intact?

Hi, my fme script, which i have runed for several times stuck, saving index. Can someone explain me the log, to fix the problem. All other proceses runed ok. 

Hello,I'm looking to read a feature class from a GDB (for testing purposes, but eventually this will be many feature classes so this process requires minimal manual handling) and add the date on the end YYMMDD and write back into the same GDB.E.G READ - "TEST"WRITE - "TEST190415"I've look at ways of doing this and not many seem to work. The closest I've got is to set the reader to expose the 'fme_basename' -> Date/Time Stamper -> Date/TimeConverter (adding _date column to attributes) -> Attribute Manager where I add a new attribute called "New_name", the value is @Value(fme_basename)@Value(_date)The write is set to Dynamic Schema Definition with the source as the GDB used and the Schema Definition Name set to "New_name". The output is the GDB name. When I edited this to just the _date, the output was the date.So the basename is being read as the gdb, and the date is being picked up in the new attribute. Can someone p

Hi there,I've never had to use the workspace runner before, and I'm kind of lost on how to set it up in the way I need it to function.So currently I have a very simple workspace that is essentially just a SQLCreator and an Excel sheet writer outputting some measurement summaries. My SQL statement connects to a PostGIS database, which contains a list of per-country tables. All these tables are named the same (i.e. "France_full_2019", "Ireland_full_2019") except for the country name.In this workbench I added a plain text parameter in the SQL lines instead of a specific country, so in this way, running the workbench, I can type "France" in the parameter window and get France's data. This all works perfectly fine and as intended, but of course limits me to 1 country at a time...This is where my request comes in:I want to know how to use the workspace runner to somehow input an entire list of countries and have it run the above mentioned workbench f

Dear all,I hope you can help to solve this question. I need to calculate Length ranges and I have as data class and Length. Can you help me please?Class Length Lenght-rangesA-1 100 100A-2 250 (100-250) = 50A-3 300 (250-300) =50B-1 10 10B-2 30 20B-3 80 50C-1 40 40C-2 100 60C-3 200 100

Hi, I'm creating a new feature service in ArcGIS Online and it works great except the writer coordinate system is ignored, I get the default web mercator (3857). Is a particular version of coordinate system required on the features or how do I get the writer one respected? I know my desired CRS is supported by AGOL. Thanks all.

Hi everyone, I would like to get outline polygon of multiple polygons that group by some attribute. Currently, I have used HullAccumulator which works perfectly unless the polygons are not curvy. Any idea how can I get outlines of those two polygons or a curvy polygon in the images?

I have folder that contain multiple shapefiles (polyline, polygon, and point), and I would like just to copy of all polyline and save to a new FGDB, there is a filter could help me, I used geometryfilter and multipleGeometryfilter, but the transformer create one feature class, I would like to get the data separate. thanks in advance

Hi all, I have overlapping polygons and I am using Dissolver to avoid this. However, I would like to keep some attribute from both polygons that are overlapping in case attribute value is different. For example, those polygons have attribute calls "Side" and i would like to have list of these in case of both polygon has different value for it such as Side = W and Side = E but if both attribute Side = W and Side = W. I want to do it because in some cases i have 6 polygons are overlapping and if i generate a list regardless from the values of those attributes, I am having very long attribute list. Thanks in advance. Best

Hello. I have a shapefile, in that, I have added some fields which are populated with error remarks. Now I want it to be pivoted with the error wise count. please see the image attached.

Hello,The BulkAttributeRenamer in FME 2019.0 build 19238 seems to have some issues. For example,Regular Expression Replace: Backreferences (back slash and number) won't be replaced with the referenced sub-string.Attribute Name containing Multibyte Characters: The attribute value won't be assinged to the renamed attribute.See also the attached workspace: Workbench interface looks fine, but... the result is wrong.In the example above, the resulting feature should have these attributes.NameValueTEAM12345prefix_?a?_sufixb

I'm trying to intersect a line with several hundred polygons the problem I'm having is there are several polygons that overlap each other, so when I run the lines and polygons through the clipper I end up with some incomplete segments. Pictured is an example where the overlapping polygon got the start of the line segment thus not a complete line for the red selected polygon. I've tried a bunch of different transformers and end up with the same result or worse result no matter what. Update: the help mentions intersector for my situation but I can't figure out how to get at the result I need still.

I am creating an XMLtemplate that loops through all the id\\value pairs in a list and creates an XMLelement for each. I got the looping working after reading through some of @takashi's post replys, but the $i variable is not getting passed correctly into the fme:get-attribute function on the list number. Am I going about this wrong? Is there a different way that I need to call the variable inside the function? <update_transaction object="ObjectNameHere">{for $i in (1 to xs:integer({fme:get-attribute("_Result_count")}))return (<attribute_value name="{fme:get-attribute("Inspection.Results.Result{$i}.id")}">{fme:get-attribute("Inspection.Results.Result{$i}.Value")}</attribute_value>)}</update_transaction>  

Hello, I am trying to interpolate a raster surface from 3D points in FME like the Trend tool makes in ArcGIS but I couldn't find any tool like it. ArcGIS Trend tool definition: Interpolates a raster surface from points using a trend technique.  Is there anything similar? Thank you 

Hi everyone,I'm quite new to this community so I apologize in advance if I make some mistake in the introduction of my question.I have a column with building names (dromore lodge, killowen house, church of jesus etc.) and I want to use PythonCaller to capitalize each word except some of them like the articles (a, an, in, of...). I've tried this simple code with poor results :import fmeimport fmeobjectsimport re def processFeature(feature):    str=feature.getAttribute('BUILDING_NAME')    exceptions = ['a', 'an', 'of', 'the', 'is']        for word in re.split(' ',str):        if word not in exceptions:            word = word.capitalize()        feature.setAttribute("B_NameCap", word)     passWhat I have as a result is the last word capitalize as I want (Lodge, House etc.) in the column I've created (B_NameCap). I understand Python is giving me the last result overwriting the first one in the list.I've tried to .append a new variable with the capitalized data and .join the data anew to no

Hi there,I wonder anyone can help me on my query. I have a Point dataset and a Polygon Dataset they on ESRI file Geodatabase format.I have over 700 circles and 7million PointsPoint Data contain Premise Count , so I will require to sum up all Premises by each Circle and assign that number to each circle, including overlappingI have used Spatial Relater/Spatial Filter/Clipper none of them give me the correct answer. Let me know if this can be done using FME .  thanks,Regards,Pushpa

Hi,I'm trying to create Index on attributes for a feature class inside FGDB. I'm using SQL to run after write option available in Feature writer. But i'm getting invalid sql statement. But it works fine when I tested in sql developer. Below is the sql, FME_SQL_DELIMITER ;DECLARE strColumnNames VARCHAR(200); P_COLUMN_NAME VARCHAR(200); strStatement VARCHAR(2000); P_INDEX_NAME VARCHAR(200); P_TABLE_NAME VARCHAR(200); ind NUMBER; indexCount NUMBER;BEGIN strColumnNames := '@Value(idx)'; P_TABLE_NAME:= '@Value(processname)_WM'; ind := instr(strColumnNames,','); indexCount:= 1; WHILE ind > 0 LOOP P_COLUMN_NAME := SUBSTR(strColumnNames,1,ind-1); P_INDEX_NAME:= P_COLUMN_NAME || '_' || indexCount; strStatement := 'CREATE INDEX ' || P_INDEX_NAME || ' ON ' || P_TABLE_NAME || '(' || P_COLUMN_NAME || ')'; dbms_output.put_line('Statement is : ' || strStatem

Hello, I'm having issues when trying to get the BulkAttributeRenamer to perform the following: I need trim all attribute names down to only 10 characters in length. When I set the Parameters for Action: to Regular Expression Replace and use this regular expression:^.{10} I'm able to match all the first 10 characters, but I actually don't need to replace these, I just want to use the matches to become the new attribute name. Am I going about this the wrong way with a regular expression? Any help is greatly appreciated.  Example:Old Attribute Name ----> AREA_IMP_TEAMNew Attribute Name ----> AREA_IMPL_ 

Hi, I am having a litlle trouble on labeling the road network using mapnikrasterizer.I am looking for some advise on this matter.So I am creating a tilled map for UK on a large scale, unfortunately I am not being able to label the road network, I have tried a lot of parameters, but I haven't reached my goal so far. please see the image bellow, as you can see the roads doesn't have labels at all. the image bellow show the parameters, used for labeling please let me know if you have any idea on how to manage this thanks for your help