Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 12,991 Posts
  • 51,878 Replies
10000 Posts
nikkik
Contributor
nikkikContributor
asked in Transformers
Concatenate fields with space in between

I am trying to concatenate 6-7 fields to create single field with spaces in-between different field values to create a address like string, no commas needed. Can I do it in text editor?             Field1  Field2  Field3 original: 123     ABC      Street                   Filed Combined  Target:    123 ABC Street 

817
alexbiz
Contributor
akeeri
Contributor
akeeriContributor
asked in Transformers
Convert dwg to shape by colors

Sometimes when I do a transformation from dwg to shape everything is included in 1 polyline (text, pipes, arrows) and when I look at it in inspektion mode I see that the dwg is splitting the lines by color, how do i do the transformation with a separation by color or adding the color value inside the whole polyline Sorry if my vocabulary is wrong

466
nielsgerrits
VIP
K
katrinaopperman
asked in Transformers
How to Use Summary Output from Statistics Calculator as part of calculation

Hello,This should be a very simple thing, but I just can't figure out how to do it!I want to append two tables together (Tables 1 & 2), both with very similar attributes, but I want to use the ID from Table 1 as the official Primary Key, and then get the highest number from that PK and increment upwards to create new PK values for the Table 2 appended values. I can get the maximum value from Table 1 using StatisticsCalculator, but I can't for the life of me work out how to use that value in the creation of the new Primary Key.I've been trying to do a conditional value calculation in Attribute Manager, something like, if Table 1 ID has a value, then PK = Table 1 ID, else use MaxValue from StatisticsCalculator and sum it with @sum(@double(@Count()),1.0) to increment up. But it's not working.Any ideas greatly appreciated!Thank you!Katrina

2295
jtorre5363
georgiec
Contributor
georgiecContributor
asked in Transformers
Difference between SPHERICAL_MERCATOR AND SPHERICAL_MERCATOR_0

I am Featurejoining the output from a change detector that compares an original layer from ArcGIS Online to a revised layer from my Geodatabase.    Note:  The AGOL layer was originally published from ArcGIS Pro from the coordinate system WGS 1984 Web Mercator (auxiliary sphere) .The Featurejoiner transformer rejects the features saying: “Coordinate system does not match first feature's coordinate system”Similar to the issue as seen in https://community.safe.com/topic/show?tid=20659&fid=8When I inspect the original and revised features, my features on AGOL have “SPHERICAL_MERCATOR” and my revised features have “SPHERICAL_MERCATOR_0”In  my workspace, my revised features are reprojected with ESRIReporojector to WGS_1984_Web_Mercator_Auxiliary_Sphere before entering the change detector. They then show a Coord system of  “SPHERICAL_MERCATOR_0”.    FYI  The ESRIProjector does display a warning saying “2.1_EsriReprojector: Ignoring input feature coordinate system `_MGA2020-54_FME_0'. This

341
georgiec
Contributor
nicholas
Contributor
nicholasContributor
asked in Transformers
How to read a JSON file from waze

I have a JSON file from waze that I am trying to read.I am using the JSON (JavaScript Object Notation) reader.There are three schema; alerts, irregularities and jamsI can read alerts okay with this queryjson["alerts"][*]Flatten Nested JSON values into Attributes = YesRead Entire Feature as JSON Fragment = Nowhich reads 433 alerts, each with a location.x and location.y which allows me to built a point object (Vertex) for each feature.But I am struggling with the irregularities and jams.The irregularities have a line object which obviously does not convert into two neat columns.How do I read the line object?I have attached the json file here

1443
desiree_at_safe
Safer
nicholas
Contributor
nicholasContributor
asked in Transformers
How do I relate the version number of a Transformer to the Version number of the software?

Hi All,I have set up my tool tip to tell me the version number of a particular Transformer in my workbench.Is there a way of relating the version number of a Transformer to the version number of my software?Can I find out which version of the software that a particular Transformer has an upgrade?For any particular software version, is there a list of the version numbers of the Transformers?Thanks,Nick

632
desiree_at_safe
Safer
gbcfgeo2025
Contributor
gbcfgeo2025Contributor
asked in Transformers
Series of equally spaced points along a 3D polyline

Hi everyone, I have a question: how can I use FME to create a series of equally spaced points along a 3D polyline provided as input from a DXF file?

455
nielsgerrits
VIP
aron
Supporter
aronSupporter
asked in Transformers
Help me sort out the PythonCaller syntax from where AI left me to fend for myself

I don’t have an programming background, so please bear with me. I need to find out the circular standard deviation of the rotation attributes from a set of features in degrees.The built in AI in the PythonCaller has taken me as far as the code below. I have tried many different prompts, they use somewhat different methods to do the calculations, but all throw errors about missing methods or incorrect classes. It seems that the AI is unable to initialize the script “The FME way”, or I have not figured out the correct prompt.What do I need to ad to the script in order to get the below working? My desired output is the circular_standard_deviation as a new attribute.Another nooby question, what should I write in the box: Class to process features? import mathimport numpy as np# Function to calculate circular standard deviationdef circular_standard_deviation(angles_deg): angles_rad = np.deg2rad(angles_deg) sin_sum = np.sum(np.sin(angles_rad)) cos_sum = np.sum(np.cos(angles_rad))

443
aron
Supporter
aron
Supporter
aronSupporter
asked in Transformers
Identify depression Contours?

Have a DTM. Am creating contour lines. Are there any tools in FME that can be used to identify any Depression Contours in the data?

755
aron
Supporter
hlynur
Contributor
hlynurContributor
asked in Transformers
Emailer referencing the workspace result

Hello, so we have now switched from Server to Flow and all is good and great except from one bit, and that is there have been made some changes between these versions that have made my emailer workarounds from Server useless.So what we did before is that we just set up the Emailer in the workspaces and sent automatic answers in the ‘Body’ section of the Emailer such as:p>Hello Colleague</p><p>Here is your GeoJson to DWG/Shapefile datapackage:<a href="$(FME_SERVER_DEST_DIR)">Click me to download</a></p>Where the ‘$(FME_SERVER_DEST_DIR)’ was the download link for the result and it worked very well.But now on Flow it doesnt work, the email sends and all but there is no value being fed into the ‘a href’ so now download hyperlink for the message.What has changed here, is it only the value for the URL and if so what value should I be referring to now to get the result data on flow downloadable?If this has now been made very different then what should I be doi

191
hlynur
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Conditional Parameter Visibility FME 2022

Hi All,How can I add a conditional parameter (visibility) in FME 2022? I know it’s possible for 2023 but can’t find it for 2022.I have created a workflow that allows the user to export data into different formats (E57, CAD, LAS, XYZ) and I want to offer the option to export the data as DWG or DXF if the user picks CAD, some images below: ...then the user only has the ‘Choose the output CAD format’ enable if CAD was chosen in the first parameter. I’m on FME(R) 2022.2.5.0 (20230329 - Build 22795 - WIN64)

211
j.botterill
Influencer
R
robinb
asked in Transformers
Lineonlineoverlay - exclude self-intersections

Hello,I am using LineOnLineOverlay to detect intersections within a polyline dataset. I am only interested in intersection points that involve more than one feature, and would therefore like to exclude any intersection points where a feature is intersecting against itself.Using the attached image as an example; I wish to ignore the intersection where line A is intersecting itself, but need to record where lines A and B intersect, and where line C crosses over line B.TIA,RB 

694
takashi
Influencer
mariuszwojcikgb
Contributor
mariuszwojcikgbContributor
asked in Transformers
FME 2018.1.2 shutdown at start

Recently two independent installations of FME 2018.1.2 crashes at start. Has anybody had similar situations and may suggest how to identify the root cause?

705
magm
Contributor
izabreton
Contributor
izabretonContributor
asked in Transformers
How to Retrieve Error Messages During Translation and Send via Email (FME Form)

Hi everyone,I'm working in FME Form (not FME Server), and I would like to capture any error messages that occur during translation and send them via email using the Emailer transformer.I tried using the LogMessageStreamer transformer, but it seems that it doesn't capture error messages — only warnings and general log info.Is there a way to retrieve the error messages (or even the full log) during a translation, and pass them into the Emailer transformer?I'm looking for a solution that works within FME Form. Any ideas or best practices would be greatly appreciated!Thanks in advance,Isabelle

735
runneals
Contributor
J
jryan
asked in Transformers
Line on Line Overlay - Comparing one feature set to another

I think this is a simple one, but for the life of me i cant seem to figure it out.     I am running a line on line overlayer and only want to compare 1 feature dataset to another (i.e. i dont want features from the same input dataset to self intersect).  Thanks in advance.  I am running FME2011.  

1026
sammy
Supporter
aharport
Contributor
aharportContributor
asked in Transformers
Incorrect cell scaling after running Bentley MicroStation Design Writer

Good morning, I'm trying to write some geodb_point features (cell) to a DGN using Bentley MicroStation Design Writer. The MicroStation cell library must be specified in the writer's parameters. The cells are placed in the DGN, but they appear incorrectly scaled compared to the cells in the cell library. If I refresh the cells in the DGN again from the cell library, they appear correctly scaled again. Unfortunately, I have to perform this step manually for each cell. I've tried adjusting various settings in the writer's advanced parameters. To no avail. Can anyone help me?

281
raghavendrans
Supporter
aaannas
Contributor
aaannasContributor
asked in Transformers
transformers for spatial analysis

Hi everyone,I am new FME user and I will be grateful if i could get some tips what transformers should I use for such an analysis I need to do:I have two addresses’ database (one is reference), both contain addresses (points) and one contains buildings (polygones). i have to compare that dataset: if addresses are on the building or not and if not how distance is betwen address and builiding. If postalcodes are correct; for example if addresses on street x have all the same postalcode. if address is located on correct street and correct town/village.

495
raghavendrans
Supporter
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Generic Writer - LAS format / Allow user to select format

HI All,I have prepared a workspace that allows the user to clip a LAS file and export it to LAS or DWG. I was thinking to use the GenericWriter to include the options for the user….but the transformer fails when trying to export as LAS. The reason for that is because I have included a PointCloudToPointCoercer right before the writer to make sure the points are written to DWG however the fme_point geometry isn’t allowed by the LAS format as requires point cloud geometry. Here is a visual screenshot of the workspace: I have included (for now) an additional LAS writer that skips the PointCloudToPointCoercer and writes the LAS file as point cloud geometry…How can I modify the User Parameters to allow the user to chose one writer (LAS) or the other (DWG)?  

152
galigis
Enthusiast
K
kaz
asked in Transformers
ChangeDetector User-Parameter for Selected Attributes can't be triggered from a workspace runner (FME Desktop 2021)

Hi  I have spent far too many hours trying to make the change detector dynamically pick up changes. The scenario is: I have 10 datasets that need to be compared between the original and updated databases. Each dataset has only a few fields that need to be checked for changes. These fields are different for each dataset. I have a CSV which is acting as a 'config' file and contains a list of the field names to check for each datasetI have 2 workbenches; the first workbench gets all of the information from the config file, then passes through the information via user-parameters to the Change Detection workbench via workspace runner. Even though I have created a user parameter for the "Match Selected Attributes" config in the ChangeDetector, I can't pass through this information via the workspace runner. It ONLY works if I run the Change Detection workbench individually, and this isn't linked to the config file, so it's not dynamic at all.  I got so frustrated

592
paul_haakma
Participant
deanhowell
Influencer
deanhowellInfluencer
asked in Transformers
JSON Templator Correct Syntax

I need to output a list of paired values as a JSON File.I have a list called JSONList with two attributes JSONname and JSONvalue.I am using the JSONTemplater to organise the data.I have the root template set as{  "publishedParameters": [    fme:process-features("SUB")  ]}and the SUB Template as{  "name": fme:get-list-attribute("JSONList{}.JSONname"),  "value": fme:get-list-attribute("JSONList{}.JSONvalue")} but I am just getting the name and value as a single line each.  How do I change the structure so each name and value pair are separated, similar to the below? {  "publishedParameters": [    {      "name": "_portalLayer",      "value": "parks"    },    {      "name": "_portalOrganisation",      "value": "SWR"    }  ]}

303
deanhowell
Influencer
coopersykes
Participant
coopersykesParticipant
asked in Transformers
How to get a list of Asana tasks with their corresponding custom field values?

I have been able to successfully connect to Asana by using two resources (attached at the bottom) and extract a list of task names and custom field names, but I have been unsuccessful in using the JSONFormatter, JSONFlattener, and the JSONExtractor tools to create a list of tasks and their corresponding custom field values for a specific Asana project. If anyone is experienced in working with the Asana API to collect this kind of data from a particular Asana project, I’d be really appreciative of any helpful tips to create a final output of a project’s tasks and their custom fields. Thank you so much!https://hub.safe.com/publishers/safe-sandbox/web-connections/asana)

480
coopersykes
Participant
deanhowell
Influencer
deanhowellInfluencer
asked in Transformers
JSON Templator for Parameters

I am reading in a very poorly formatted JSON file which has hundreds of lines but I just want to extract some key attributes that will then be used to create a JSON file that can be passed to FME Flow to start a work bench using the extracted attributes. I am reading the JSON file in and running it through an attribute manager to get the attributes I need. If I then run through JSON writer I just get a list like this[    {        "json_featuretype" : "JSONFeature",        "Catalogue Key" : "Data Catalogue",        "Layer Name" : "Testville Roads",        "Data From" : "Import type from CSV file",        "Data Access" : "Restricted",        "Update User" : "Alex",        "Description" : "Roads data for Testville COuncil",        "Dataset Dimension" : "3D",        "Data Update Frequency" : "As needed",        "Geometry Type" : "Points",        "Spatial Presentation Type" : "Vector",        "Data Currency" : "2025-11-09",        "Initial Publication Date" : "2025-04-15",        "Contact"

272
deanhowell
Influencer
albinepro
Supporter
albineproSupporter
asked in Transformers
Debug Python Scripted Selection

Im trying to implement some dynamic selection based on an API call response. So far I can build a package for scripted selection according to Dynamic choices using Scripted Selection - FME Packages SDK Guideand debug in VS Code attaching to Workbench (Build a Hello World package - FME Packages SDK Guide).The problem is that debugging is bound to running the translation and that is already late for the script I need to debug. The selection scripts are run when filling in the transformer parameters. I need to add breakpoints and inspect the execution of selection script (ScriptedSelectionCallback) during the API calls and browsing the object structure. Is there some setup to make this possible?The final purpose is to get this into User parameter scripted selection in FME Flow. I understand it would work this way in scripted parameter selection as it is in the transformers.

514
albinepro
Supporter
mgrupp
Participant
mgruppParticipant
asked in Transformers
ArcGIS portal feature writer fails to fill certain fields when run on FME Flow

Hi everyone,I have a problem that I can't seem to solve. I have a workspace that writes data from a PostGIS database to a feature layer on our portal using the ArcGIS portal writer. When this workspace is run locally on FME form, it works perfectly fine. When it is uploaded to portal and run there, it seems to work fine (the amount of features written is identical to the amount when run locally), but some important fields are not filled. Flow and Form both use the same web connection with the same authorization parameters. Why is it that a identical workspace that runs locally can fill all fields fine, but when run on portal it seems to not be able to fill these fields??? I have put testfilters and loggers in between to check if the fields actually have values and they do, so it must be a writer quirk. Field names between the features and writer are identical as well (all lowercase) so I am at a loss... I am using fme form/flow 2023.2.2 and ArcGIS portal 11.1

573
artw
Participant
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Transformers
adding points to the line

Hi, I have a task in which I have some points attached to the line. I need to select point values and split the line at the point.I have attempted to generate points between two points using the Densifier transformer, but I am not achieving the desired outcome. If someone can assist me in this situation, I would greatly appreciate it.

875
fme_can_do_it
Enthusiast

Badge Winners

  • Student (Grey)
    cbateshas earned the badge Student (Grey)
  • FME Certified Trainer
    erik_janhas earned the badge FME Certified Trainer
  • Integrate Spatial Data
    laisgouldhas earned the badge Integrate Spatial Data
  • Student (Grey)
    wthallhas earned the badge Student (Grey)
  • Teacher (Grey)
    evoteck-gchas earned the badge Teacher (Grey)
Show all badges

Community Stats

31,240
Posts
118,445
Replies
38,833
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.