Transformers

I've scoured the help pages and cannot seem to find the answer. I don't want to just copy and paste my python script in to the Startup Python script, I want to actually run the file and config file from FME. Is this possible?

Hi people, I have a list of addresses which needs to be split from 'Street+BuildingNumber ' to 'Street' and 'BuildingNumber'.  I have a file with REGEX that might work on these addresses, so running each REGEX one by one (in top-down order) against my addresses will eventually split the address into Street and BuildingNumber.Once this is achieve, it goes to the next record and try to split it with those REGEX. Is there a way to achieve this? As it is a lot, I don't want to use SQLCreator and put every REGEX in there. Looking forward for any light at the end of the tunnel...

Hi,I have some points (boundary stones) that should be aligned on the contour of boundary polygons. Since the field location accuracy is known to be inaccurate, I want to snap the points to the contour of the polygons.I supposed that AnchoredSnapper was the transformer to do this. And it seems to work fine. However, when I further apply a PointOnAreaOverlayer transformer, although all the points visually seem to be on the polygon contour, some points have 0 _overlaps.when I check the output of PointOnAreaOverlayer some snapped features have _overlaps = 0I was careful to link the snapped output of AncoredSnapper to PointOnAreaOverlayer.What am I missing ?

Hi,I would like to read a json file from an url. Read only the schema and translate the schema to be the main attributes in my workspace. So I'm able to map another dataset onto the main attributes from the read json file.  Example json dataset:{ "json_featuretype" : "ExampleDataset1", "Attribute1" : 100, "Attribute2" : 5, "Attribute3" : 0.7, "json_geometry" : { "type" : "LineString", "coordinates" : [ [ x,y ], [ x,y ] ] } },After reading the schema I would like to see something like this in my attribute manager. I would like to automate this proces and not manually enter the attributes in a attributecreator/attributemanager. Since attributes can be added to the read json file from the url in the future.  I tried

I am currently importing a dgn file into FME and I am trying to filter the cells based on the following attributes igds_cell_name and igds_cell_insertion_x/y/z . With the AttributeFilter one is able to filter based on one attribute, however I would thus like to filter based on the above mentioned 4 attributes , so I can aggregate afterwards the cells that have the same value for the above mentioned attributes. Does anyone know how I might be able to achieve that. I wouldn't want to make use of a TestFilter, since with a TestFilter you have to write manually out all the possible values with AND clauses. That would be too much work for me.

 my department should provide me with data to read by FME but they requires me to choose the format file for the data that FME could read and works at higher performance as excel ,csv ,sqlite ,...etc . other formats are available also .which format from your experiences will be best performance than others ,why ?FME Desktop 2020Thanks in advance.

I have a table of linear sections, each with a unique SectionID. Each section has From XYs, and To XYs. There is anywhere from 1 to N points between from and to, depending on the section.  Right now, each row represents one of these "in-between" points, with a SequencenNumber attribute saying what order they appear in.  My goal is to create 2 additional rows per SectionID. One that is sequence 0, and populates the regular X and Y fields with the From XY values. Another that is sequence N, where N is the highest occuring sequence number, plus 1, that populates the regular X and Y fields with the To XY values. I can re-order them afterwards with Sorter if need be, but they need to be in order both by sectionID and sequentially so that LineBuilder draws them properly. I know I can group by SectionID in LineBuilder as well.  I'm a bit of an FME noob, so any help would be appreciated! I really can't think of what transformer or

I have an attribute that contains a string with 1 or more comma separated integers. The range of integers is 1 to 13. Here are some example values:102,3,57,8,9,103,25,6I need to replace each integer with a text value that I've looked up from a table such as an Excel file. I know how to use the DatabaseJoiner to look up values, but I'm not sure how to process a list of lookup values. Ideally, I'd like to sort the integers before looking up the text values. For example, "3,2" would be "2,3" before the lookup. I'd also like the option of separating the text values with a new line character instead of comma. Is what I'm trying to do possible with FME Desktop?

Hello! I have not been able to figure out to generate polygons from the roads that are of intresest. What I need to do is to generate a polygon from all points that are within 3000 meters from "from_point". That park work fine. But when I try to genereate the surface it doesnt follow the lines good enought. It's to generalized. Please se the PDF to see what I mean.  How do I generation the surface so they follow my routing better? For this task is very important because the roads are filtered only to use safe roads to my target group. With the results I get now from hullaccumulator sometimes points will be inside the polygon even tough they should not be.  Only the points that has 3000 meters or less should be included in the surface. Can anyone help me? Best regardsJesper

Hi all, I am trying to filter and extract rows from dataset A based on partial and exact match to values of dataset B. Dataset B will be different each time I run the workbench.B is actually a subset of A, generated from a separate query as part of another process. So There will always be an exact match, but there may or may not be partial matches. Where partial matches are found it will be in the form of a suffix to the ID (eg ‘v1’ at the end).My reading of this forum suggests there are two issues that make this filter more complicated: 1. dataset B is an output of another query so the values will always vary2. I need to extract instances of partial matching as well as exact matching. example:dataset A (n=4000)IDMRR_1234v1MRR_1234v2MRR_1234TR_5678TR_5678v2FG_9876 dataset B (same table structure at B, n<20)IDMRR_1234TR_5678 i wa

 I tried with the transformer "substringextractor" but I remove the "1" from my thousandth when there is no comma at the beginning.  I saw that there was a transformer "LastSectionOfStringRemover", maybe it exists for the beginning? 

Hi, How can I format a string with leading zeros (eg. seven zeros) through the "Format" string function in text editor?For example, in attribute creator, I want to create a new attribute which takes input id field (e.g. its value 5), and I want to return 00000005.The screenshot below better elaborates my case. Any help is highly appreciated.Hani,

I would like create a MSWord document that includes a table that has 3 columns. The first two columns are just attributes, but the third should be a thumbnail image, whose path is stored in an attribute.  I can use the MSWordStyler to generate a table, I can also use it to add the pictures. What I haven't been able to figure out is how to add the pictures in the 3rd column of the table.

I have the xml file relating to a Geocortex Essentials site, from which I'm attempting to extract elements as FME features. However, I can't even get beyond parameters > elements to match, as I get this error: It seems to infer a format error? (I'm entirely new to XML, btw), but this site is functioning ok. Any ideas? Many thanks

Hi, I was asked to write a raster of an Digital Terrain Model to an Esri ASCII Grid file. However, the aim of the end user was to maintain a precision of 3 decimal values for the pixel values, so that the file size would not get too large.  To illustrate the question I created a short sample workspace.A visual preview of the RasterNumericCreators result is shown below;At the red dot (row,col) = (0,2), we can see that the pixel value is equal to '0.0250313' (using a ~'data value encoding' of 'Real32'). After the RasterCellValueRounder, we see that the value for this s

I am trying to use the looping functionality to calculate the cumulative sum of values to match a certain value (budget). Those that are less or equal to that value are saved out as output and those that don't match should go to the loop and be processed again till all the features are processed. Any idea to make it working. Thanks

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)).   

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

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?

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.

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 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