FME Form

I am currently trying to extract the dominant value from a given row and populate a field with the dominant value from one of the dominant fields while associating it to another value in another field.  This is how to interpret the table in general.AreaCount1 is the count for area one in AreaName1 field.AreaCount2 is the count for area two in AreaName2 field.so... on and so forth. For example:For UniqueID 10 the dominant attribute from the six AreaCount columns is 1736 (see image below). I am able to extract the dominant value by creating a new DominantValue field and applying this math function @max(@Value(AreaCount1),@Value(AreaCount2),@Value(AreaCount3),@Value(AreaCount4),@Value(AreaCount5),@Value(AreaCount6)).   

I am trying to write from Excel to Azure. The writer table has no primary key as it is just a staging table and doesn't need one. FME will not allow me to write to it unless I set a primary key. Azure lets me write to the table within the server so it seems like it is only FME requiring a primary key. How do I get FME to write to a writer with no primary key? This is the error message (I am not creating a new table):Microsoft SQL Server Non-Spatial Writer: Failed to create Azure table 'dbo.test_survey' because no clustered index or primary key was specified. If creating a new table, go into the 'User Attribute' tab and set the 'Index' column to 'clustered', 'clustered_not_null', or 'primary_key' for a column And these are the settings

Hello everyone. I know there might be not too many using the DatasmithWriter (since I didn't find any question about it here yet). But I hope maybe someone can help or has an idea. I'm using the DatasmithWriter and got a surface that has a raster placed with the AppearanceSetter. This Raster has an Alpha Value (it's a branch, so everything around is meant to be transparent).When I write the DatasmithFile it tells me Raster could not be written (nothing more).When I remove Alpha Band it works, with Alpha it doesn't.I read Details about Datasmith, it says 32Bit, Alpha8, Int8.This is all the case for my Raster so im running out of ideas what might be the problem. Thank you in advance for any hints.

I'm reading in data from a filegdb which has an attribute of type float. I'm then writing the data to an ArcGIS Portal featureservice which has an attribute type of double. The data is read into fme with a type of 32 bit real and a value of 77.56, when this ends up in the Portal featureservice this ends up with a value of 77.55999756 Now I think I understand where the 77.55999756 comes from as if you convert 77.56 to 32 bits of binary and back again you get 77.55999755859375 But what I'd really like is for the double field to end up with a value of 77.56 (77.56000000000000227373675443232059478759765625) . Now i can achieve this by converting the attribute to a string and then to a 64 bit real value in FME before sending as an update to the writer. This then returns a value of 77.56 when i read the data back into FME which matches the value in the gdb. It also matches what would happen if I went into the portal front

Hey There,I hope another set of eyes on this might help. I am having trouble with Python scripts and the Python Caller. I generate the error 000816, which I have tracked down to a possible conflict between 32 and 64 bit versions of Python conflicting with ESRI geoprocessing tools. I have attached a screen cap of the log. I have highlighted where I think FME is using 64 bit but I have set the Preferred Interpreter to the 32 bit in the Tools. Any thoughts? Many thanks and all the best!c.

I have a date being read in from a SDE geodatabase. It is in M/D/YYYY. I have the user input a year. I want to test it against the year in the table and only select the years that match. Is it possible to parse out the year in the tester or do I have to add in a DateTimeConverter Transformer to change the format?

We have an fme server installation running on linux with dynamic docker engines set up. We are using FMEServerJobSumitter but missing the control limit offered on the WorkSpaceRunner by the maximum concurrent processes or similar. I have gone over a few documentation and knowledge base articles to find how to limit the amount of dynamic engines processing on a certain queue to avoid exhausting all licensed engines available globally on FME Server . How safe recommends this ?  Regards,Jorge Vidinha

HI !i'm starting using FME 2018 and i would like to do something very special i don't know if i can do it ? So,i want to match two table with one attribute but sometimes this attribute is not the same in both.exemple :Table 1 : "restaurant le Bistrot" Table 2 :"auberge le bistrot" the special key word are not always at the same place. my first idea was to separate every word from one of these table in list with attributesplitter and using a "tester" searching at least 2 word from lists for making a match with my first Table but that doesn work. even with "matcher" do you know if my request is possible ? thanks !! Charles.

Hello Experts,I have a file in which I have 2 columns id and distance. The distance corresponds to the ids. The issue is that some ids are duplicates and the distance is different. I want to identify the ID which has closet distance associated. See the image attached. Any help would be appreciated.

Hi,I would like retrieve the date of a Excel file (in the reader). The date write in the Windows explorator.I would like write this date in a field 'version' of my new file (in the writer)Thanks a lot, 

Hello,I am trying to execute below plsql statement using SQLExecuter.But the declared variable (mId) is not populating select statement "mId" value. DECLARE mId number;BEGIN  select MAX (id) INTO maxId from @Value(table);  insert into @Value(table) (ID,@Value(columnsStr)) VALUES (mId, @Value(ValueStr));END; /FME_SQL_DELIMITER / Expected output during execution: insert into table1 (ID,name) VALUES (10, 'test'); FME Output during execution: insert into table1 (ID,name) VALUES (mId, 'test');  Thanks,G 

I tried to use WorkspaceRunner to perform a batch processing, but I didn't get the result I wanted.For example, I run 4 fme.exe at the same time in child workbrench and set the output result to same location. No matter the output location is Esri Geodatabase with 4 different names or with 1 same name, sometimes one or more fme.exe fail to write the correct result, some features will be missing.But when I set 4 different Esri Geodatabases as output locations, I can get the correct result. And this happens only when I use File Geodb Open API Writer, File Geodb didn't work either.I'am thinking maybe FME can't write to the same GDB at same time? Is there any solution to situation? Otherwise I have to do an additional Fanout processing.Thank you.

Trying this workspace, I get an error saying 'owner' feature type does not exist. The FeatureWriter output format is SpatiaLite and a template.sqlite database is used. For both feature types "Use existing" table handling is selected. Parcel geometry type is wkb_polygon and owner is wkb_none. The 'owner' table exists in the template. Could it be a FeatureWriter error managing SpatiaLite?  

Hi, Running a script to truncate an existing feature class in a sde that has attribute rules attached thru ArcPro. The warnings state the below items - table must exist - it is there, can see it via Catalog and SSMS. User has DBO. Running 2021.x FME, 2.9.2 ArcPro. Any ideas as to what I may be missing? Did set the compatibility to ArcPro, used sde connection created by ArcPro.Thanks,Lorinda2022-04-06 12:41:23|  1.2| 0.0|INFORM|Transactions are being used by the Esri Geodatabase Writer2022-04-06 12:41:25|  2.9| 1.7|ERROR |Esri Geodatabase Writer: Feature Class or Table 'IDF_Stormwater' must exist when Table Handling is set to 'Truncate Existing'2022-04-06 12:41:25|  2.9| 0.0|ERROR |GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details2022-04-06 12:41:25|  2.9| 0.0|STATS |GeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures (SortFactory): Finished sorting a total

I have set up job routing rules and I want to test that the routing rule is working fine. I have added CPU%, Memory Peak Usage, and Queue in Display Column on the grid, but there seems to be a lack of functionality on the grid or I am missing something basic.  Usecase: I want to see all the jobs which finish within 2 mins, use < 20% CPU, use <2GB memory. and want to make sure they all were assigned Micro queue. -> I am trying to filter by queue but filtering by queue is not an option.-> Grid is configurable to hide and show columns, but I can't sort by columns or add any kind of calculated field in the grid.  Is there any easy way to export this data to excel? I tried dashboards but they don't have the fields I am looking for, maybe if someone who understands the database schema of the FME server can guide us I can get help from our FME Author to adjust the workspace/dashboard to include these extra fields & fi

i have read this article and it is useful for me ,what am i looking for but i am not sure ,how could i let feature reader to work . https://community.safe.com/s/question/0D54Q000080hQidSAE/pick-up-latest-file-from-folder-location i have found one latest file that i am looking to from sampler , but how could i open this file to check the data inside and extract attributes .the file format is excel  1. As your source, use a Directory and File Pathnames reader. 2. A Sorter that sorts descending on path_modified_date. 3. A Sampler that only lets the first feature pass. 4. A FeatureReader where Dataset is set to path_windows. this is parameters that i did f

Per the TopologyBuilder documentation Generate List From Input Faces Gives the option to create a list on the Node and Edge output ports that relate to information from the input faces.  However when attempting to do so in FME 2021.2, the attributes are show on the canvas, but are not present when the Node output is inspected.Why isn't the _faces{} list propagated onto the node like is to the edge?

 In my workbench I have a WKT that I send (using HTTPCaller POST) to an API. The API then runs a background model and I need to use a HTTPCaller GET to retrieve the json results via the same API. The model can take anywhere from 5 seconds to 3 minutes to run. When the model is still processing it returns a '202' status code and when it completes successfully with a '200' code. Right now, I have various decelerators, however, this slows down the entire workspace, I would like have the HTTPCaller wait or check for a 200 response and continue the rest of the workbench immediately.

Hi, I have some buildings and I will remove internal walls.So for this I use surfaceonsurfaceOverlayer and tester to identify internal walls. That is working in most of the cases. Nevertheless I have a few buildings where the outer wall is removed like this: Maybe someone has similar problems?Is there a way to do a further check if wall lies on the building outline? If this is the case we have to keep this wall!How can I avoid this kind of problem?Thanks in advance 

I have about 2000 line segments that need to be aggregated based on a specific field. First I sort them based on the order they are supposed to be merged in, then I aggregate them if there's more than 1 segment. This results in about 1100 multipart polylines (not all of them are multipart, and some are just made of 1 segment, but others can be made of up to 12 segments).  This works really well for my output data, and the lines are all merged correctly. However, at a closer look, my elevation profiles don't make sense. It appears that even though the segments are in the correct order, some of the segments have a different orientation of their neighboring segment, i.e. one is going North to South, and the next is going South to North. Hopefully the attached diagram can help illustrate this.   

Hi, I have a file with several lines that contain information about a unique record. However only line 01 has the unique information about the property. The remainder of the lines have further information about the property and start with different numbers. The row with the main information always starts with a 01. Subsequent rows have a different number. Can someone please advise how I would add the unique reference in the example below in the second field in line 01 (19633154000) to all the rows below until you get to the next row with line 01. Many thanks. Eg01*19633154000*10870539000*0335**45-47****YORK ROAD02*1*Ground*9002*9*First*1804*12801*17163059000*7648136000*6955*WILKINSON BUSINESS PARK02*1*First*3802*3*First*0.0002*4*First*Kitchen*105*10*0**0*+0

Hi,I have polygon data of different lots of land from a city. The goal is to figure out if any two polygons together are bigger than a predefined value. That means I need to merge two adjacent polygons together, test their size and repeat that process with all other adjacent polygons. (Let's say a lot has 6 neighbours, that means I need to check 6 different combinations) This need to be repeated over the whole dataset (around 5000 polygons).The problem is I don't know how to merge the polygons individually. I tried different methods with NeighborFinder, SpatialFilter, etc. but none of them yielded the results I needed.Thanks for any input!F

In old version we just put the scripts in C:\\apps\\FME\\Python if we need to get them in Python Caller.How do we do it in the new versionsThanks

When I export a 3D solid to dwg I get a Polyface mesh instead of a 3Dsolid.How do I get 3Dsolids? 

Is it possible to filter out a single attribute value from data. I am trying to map pit data and although I have streamlined relevant pits using buffer and clipper I still have useless pits which have the same attribute value ie. 2 pits, B pits, and C pit