Transformers

Hi, this is a really basic question, but none of the other answers I've read have quite fit. What I want to do is simple - find the percentages of these two values:The answer would be NoBlank - 78.22% , BothBlank - 21.78%I'm aware the trick is to find a way to sum the Individual ID.total_count column in the Expression Evaluator, but "@sum@value(individual ID.total_count)' doesn't work, only returning the original values.  This so frustrating because I'm sure it's very simple.

New for FME 2020.1 is data-aware transformers. When data is cached via Run with Feature Caching, the attribute values can be retrieved from within specific transformers. Retrieval of these values will prevent any data integrity issues that occur with spelling mistakes and makes the workflows faster as you don’t need to keep viewing your data to get the value you want to test for or expose.  This feature is currently available in the Tester, TestFilter, AttributeExposer, and anywhere that test clauses are used.  How to Use this Feature1. Ensure that you have FME Desktop 2020.1 or later installed. Then read in your data. Run the workspace with feature caching enabled. This step is key!   2. Add a Tester, TestFilter, AttributeExposer, or any other transformer that uses test clauses. Once connected, open the parameters. In the parameters, select the Left Value attribute. For this example, I’m using Common Name. Then select your Operator.  To retrieve the cached attributes, click on the dro

For example, the user has selected 4 dates in this order:We wish to retain this date order for the output table, but after running the formatted dates through the AttributePivoter to set the dates as attributes, they come out in alphabetical order, as follows. Note that dates 3 & 4 have switched. The order of attributes should be Jun 2019, June 2020, Sep 2018, Mar 2019.Has anyone managed to deal with this issue?Thanks in advance :)

Hi, I want to count values for individual fields in excel. There are 110 fields. I want total counts column by column for all values that are not missing, empty, or null.

Hello,I have a little problem and I hope you can help me.I use the transformer xmlTemplater. It works fine. But there is one problem:If I insert an attribute with "<" or ">", the Transformer will change it in "lt&" or "gt&". Is there any option, that the transfomer doesn't change the attribute?

Dear community I have just started using FME. I have an excel sheet with some x,y coordinates in the danish s34 (DenmarkS34-S) that i need to reproject into ETRS89 zone 32. I have tried using the attributereprojector but the coordinates i get are incorrect. I have also tried the csmapattributereprojector, but i cannot find that particular transformation.  I hope you can help. Regards--Rasmus

I have a list of connections (ServiceID) that are attached to a main (MainID), that are grouped by a network ID (NetworkID). There can be one or more connections to a single main, and there can be multiple mains in a network. See example -I need to list out the mains with all possible service connections within a network. Each main ID would have all connections within that networkSo the above example needs to turn into this -I thought I would be able to use a feature merger, or joiner, grouping by network ID, with both requester and supplier coming from the same table (kind of like a many-many join) but that doesn't seem to work. Maybe my parameters are off, but I am not even sure if my logic is on the right track. I am somewhat new to FME. Any suggestions would be welcome!!

Hi everyone,I really appreciate the data inspector for z visualization of point cloud, but I can't find a way to plot or see a color bar / color scale to easily read wich values are associated with wich color. Is there's a way / trick to do this ? Thanks !

I have a folder with soil shapefiles. The schema all vary slightly and I want to merge them into a new schema. I can only connect one field to the output field. So for example, here I want to have 'PCT_A' and 'A' loaded into the output shapefile 'PCT_A' field. Can this be done?

Hi everyone,I have an output from a PointCloudCombiner with 4 components (x, y, z, _distance). The _distance attribute comes from a NeighborFinder. What I want to do with the point cloud is to replace the z component of each point by its _distance value. I tried to use the PointCloudExpressionEvaluator after the PointCloudCombiner but _distance doesn't appear in the component list. I only have access to it as an attribute (not a component) and then get the same z value for each point of the point cloud... But when I check the PointCloudCombiner output in DataInspector I can see by clicking on each point that there is a _distance component that changes with each point. How can I have access to this component for further processing ? Thanks !

I have a feature type of polygons, namely A, and want to use it as the candidate in a SpatialFilter against another feature type of polygons as the filter, namely B. B consists of a few groups of polygons, each group has an unique group name. What I want to achieve is like looping through each group of polygons in B as one filter against the same candidate of polygons of A. I see the SpatialFilter has a "group by" parameter but it requires both the candidate and filter having the same group names, which is not the case here for the candidate. Seems a simple and reasonable scenario, but I can't figure out a way to do this. Any advice or hints are welcome.

hello,I am trying to write inside an xml file elements only if a feature attribute has a value.I have 2 shp files :In first file I have "Eticheta" feature with names of the street.In second file I have "label" feature with attributes values are the same as "Eticheta " from the first file. Here, in the second file I have also "NR" which. I am trying to write in XML numbers for streets and I need to write the numbers on each street.I used an if-then-else statement that writes out the numbers only if street from first file is exactly like street from second file. in my XMLTemplate, in subtemplate I have: { if( fme:has-attribute({fme:get-attribute("label")}) eq fme:has-attribute({fme:get-attribute("Eticheta")}) ) then {fme:process-features("ADRESA")} but fails to write data inside xml file.errors from log:XMLTemplater (XMLTemplaterFactory): An error occurred while parsing the 'ADRESE' sub-templateXMLTemplater (XM

Is there a way to get AreaBuilder to produce results closer to Pro's geoprocessing? It seems that whenever I give FME lines similar to the example below, it builds one polygon and calls it a day unless I specify an absurdly high snapping tolerance, in which case it produces garbage (e. g. a 1m tolerance would create a small extra triangle in the middle of the northern line where the small /\\ is, but still leave the large area empty; 5m would create a large jaggy polygon. The example is roughly 100m across, btw.). The polygon parameters have no effect, neither do the snapping types. The lines are 2D, I've also included a 2DForcer before the AreaBuilder to make 100% sure it doesn't even get Z coordinates, but to no effect.​Pro, with all of the line vertices displayed and filled areas (three separate polygons, as expected):FME, with one polygon ☹

I managed to generate a new json from the original one getting the info I need but now I see there's some missing data.Each project group has an id, lat-lon info and an array with data for every project inside the group.I generate a new json with a feature for every project but need to also add a feature for every project group without projects in it.This is what I have:[    let $doc := fme:get-json-attribute("_response_body")    for $i in (1 to jn:size($doc))        let $id := $doc($i)("id")        let $lat := $doc($i)("lat")        let $lon := $doc($i)("lng")        let $proj := $doc($i)("projects")        for $j in (1 to jn:size($proj))            return              {|                {"id" : $id},                {"lat" : $lat},                {"lon" : $lon},                {"proj_name" : $proj($j)("name")}            |}]I've tried to nest an If statement to check when $proj is empty but it throws an error.  

Hi,I would like to use System Caller to run an ili2fgdb command (http://www.eisenhutinformatik.ch/interlis/ili2fgdb/). The command works in cmd but not with System Caller. Does System Caller only work with .exe and batch files? Here is my command:"java -jar "C:\iliTools\ili2fgdb-4.4.4\ili2fgdb-4.4.4.jar" --trace --proxy xxx.xx.xxx.ch --proxyPort 8080 --schemaimport --defaultSrsCode 2056 --fgdbXyResolution 0.00005 --fgdbXyTolerance 0.0004 --createTidCol --createBasketCol --createEnumTabs --beautifyEnumDispName --dbfile "\path\BL_Natstr_oereb_20190514_SU_4_4_4.gdb" --modeldir "http://models.geo.admin.ch"" target="_blank">http://models.interlis.ch/;http://models.geo.admin.ch" --models OeREBKRMtrsfr_V1_1 --log "\path\BL_Natstr_oereb_Schemaimport_Log_4_4_4.txt""How can I execute this command directly in system caller?  Any help is much appreciated!Many thanks in advance.  

I am having trouble in FME to find the correct scale in model space to find the correct size of text when there are multiple annotative scales and viewports. In Autocad the text element has Paper text height and Model text height, as shown below in the screenshotThis text element is in multiple viewports at different annotative scales. When viewing the 2 different viewports in paper space, one size is correct (in this example 3.5 at 1:400) and one is incorrect (when looking at the 1:200 viewport). FME sets the text size in model space using the model text height value, but we have no way to know which Annotation Scale was used to calculate that which I can see? It looks like to workout the original value we need to be able to find the model space annotative scale (set in the bottom bar of AutoCad see image below)  or alternatively we need to know the paper text height value (which is consistent when changing Annotative Scale in AutoCAD). Are either of these values saved as an attribute

Hi All,  I was wondering if anybody has any experience with reading WMTS services via FME. Any help would be appreciated. Itay

Hello there, I have a question about how the attributes are displayed in the 'FeatureJoiner'. I did an inner join (pic- feature joiner parameters box) with my two dataset and selected the join port. I viewed the data in Data Inspector and found the attributes from both datasets are not displayed in the attribute table (pic- 2nd picture, only displaying attributes from the right dataset) but only in the 'Feature Information' box (pic- attributes displayed from both). My question is, how do I get both features to display in the attribute table? 

I have 2 Columns.First Column is the Date.The second Column has a value.I want to see for each Day in the first Column the sum of the last 7 Days.How can i do that in FME?

Hi, I am trying to essentially take one raster over another to produce one merged raster. With some simple logic if cell is present in raster B choose raster cell B otherwise A. When I do this the transformer just outputs and empty map. what am I doing wrong? Thank you

Hi.I added 2 new resource folders to FME Server 2020. I simply defined the shared resources by adding the corresponding lines to fmeServerConfig.txt and FmeEngineConfig.txt files, restarted FME Server services and voilà.Now I need to remove one of these resources from FME Server but removing them from the config files and restarting FME Server takes no effect. It still appears in the resource list.Did I miss any step? Is there anything else I should do?Thanks!

Hi I have a road segment line/polyline dataset that I need to split for each segment object into 10m intervals and create a new record. What's the best way to go about this? Thanks in advance Tim

Hi, I am using the RegxAttributeSplitter. My delimiter has to be digits followed by a whitespace. I have used the positive lookahead Regex (?=\\d(\\s)) but instead of splitting the string and keeping the delimiter in the first list, the delimiter moves into the second list. I need my delimiter to remain within the first list, I thought the answer would be to use Regex negative lookahead (?!\\d(\\s)) but the negative lookahead stalls the transformer completely and produces no result. Any clues what Regex I should be using? I have also tried using Regex in the StringReplacer but no positive results here either. Below is sample of the string.. H02.CCU066 Sluice (Shared 2,Rooms)  H02.THD067 Treatment Area - 14,Spaces Yellow highlight is the delimiter moving to the second list

Hi everybody, I have written a very simple script that:Reads some ESRI-JSON placed in folder tree recursively (**/*.json)For every data which is in the same folder (= same type of data), gathers all entries in the same dataset and creates a new feature class with the name of the folder in an ESRI file geodatabase (having eliminated duplicates) Precisions:Every input json files in the same folder share the same schema. But in differents folders the schemas are not the same and there may be or not M values attached to the data. However, the field OBJECTID can always be found and that key is used to remove duplicates. Issue:I cannot find the way of setting the output port to retrieve the original schema which is the same of the JSON files the output dataset aggregates. When I check "Dynamic Schema Definition" I have no choice but to use fme_feature_type (the script fails otherwise) attribute but it represents the whole schema (since all files are ESRI-JSON); so there are lots of

HelloI need to create a polyline dataset based on a point dataset which contains a text string. The text attributes also contain the orientation. As I have 1 point for each text feature how can I either :- add another point at the end of the text string and then join the points together to create a polyline, or  can I just create a polyline directly from the text string for the correct length and orientation. Any suggestions on how to achieve this would be welcome. Thanks