Transformers

Hi guys, I have the following attributes:783784AYHI would like to add 1 in front of any attribute starting with 7 and avoid adding to another field. What would be the best transformer to use for this? I have tried and tested the stringpadder but can't seem to get it working. Any help would be great.

Hi I tried Change Detector & Update Detector to compare records in 2 tables based on a unique key. Lets say input tables have 10 attributes in unchanged port output of change detection I get few records but attribute value of all except the unique key specified for comaprison is NULL. Is there anyway I can get attribute values in unchanged port as well As I need to do further processing based on these attribute values of Unchanged records.

Hello all,I have a TestFilter that directs my input data into multiple branches for further transformation and I have dozens of test conditions within this TestFilter, similar to below:If Test condition @Value(field1) = A to Output port 'Road'Else If Test condition @Value(field1) = B to Output port 'River'Else If Test condition @Value(field1) = C to Output port 'School'etc, etc..... Is there a way i can then use these port values to replace the original input attribute value for this field? For example: Replace all attribute values of 'A' with 'Road'Replace all attribute values of 'B' with 'River'etc, etcI'm trying to find a way of avoiding having to create dozens of repetitive transformers after each port to make this attribute value change and hoping to reuse the effort made thus far with in creating the existing TestFilterDoes any

For a customer, I am upgrading a FME 2015 Workflow to FME 2019. At some point, an FFS file with measures is written. In a later stage, it is read with a FeatureReader. It still contains the Measures, 0 for the starting point, 100 for the ending point. After passing through the Rubbersheeter, they are lost. The customer still has older versions available. It still works in the 2016 and 2017 versions. From FME 2018.1 (I do not have the 2018.0 version) onwards, the rubbersheeter does not output the measures. However, it is not possible to upgrade the transformer. It still has the same name. In the 2019.0 version, you can upgrade (adding the group by possibility), but the measures behaviour is still the same. Anyone else having this problem?

When I use the PointOnAreaOverlayer and the LineOnAreaOverlayer on FME Desktop 2019.1, the resulting _overlaps appear correct.When I set the 'Group by' option to group by an attribute on the either the PointOnAreaOverlayer or the LineOnAreaOverlayer, the resulting _overlaps is set to 0 for all features. @steveatsafe

Hello,I am trying to geocode some addresses. The input is excel. But I don't want to use available geocoder services. Instead, we have our own geocoding API key. Is it possible to use it through any of the transformers?

I'm sure the transformer is somewhere, but I simply cannot find a transformer that would accept stream of features with attributesvalue to calculate..and it would calculate this value into the designated field.  Example: I have a statistic calculator that I need a _max value from. I want to feed this value to all the records in the stream into a field _max. I will then use the counter to assign the ids.How can I achieve that?Thank you  

As stated in the title,I want to compare two schemas to see if they have duplicate field names.My idea is to use the Change Detector, but i do not know how to expose field names from an reader Any thoughts?  

I have an Excel Sheet where I need to find Arabic Words and separate them.For example, I have data like this://olyservice/GIS-TANSIQ01/Storage/46-????? ????? ???? -????? ??????/???? ????? ??????? ??????????????? ???????? ????????.rar//olyservice/GIS-TANSIQ01/Storage/111-????? ?????? ??????? -/Layers.zip //olyservice/GIS-TANSIQ01/Storage/100-????? ????? ???? -/????? ????? ???????? ??????? ?????????? ???? ????? ???? - ????????.rarI'm looking for:1st column: ????? ????? ????2nd column: ????? ??????3rd column: RARIf there is no ????? and ????? words, the columns should be blank.Is there any transformtion and formula which i can to get the information ??

What I want is to detect (new) buildings from a aerial photo. I have a 7.5 cm resolution aerial photo. Furthermore, I already have a large dataset with polygons of buidings (around 150.000 buildings). Can I use this dataset to create an annotation file for the positive samples to use in the RasterObjectDetector?  And can I also create negative samples by taken regions from the aerial photo where no buildings are located?

I have Google Spread sheet for project Managemnet .. what I am trying to do is end of week i get the Value from one specfic column and add on week Number Im attching the week FLow where you get the idea what extacly im looking for  i just need get percentage from Sheets  

normal reader is used not feature reader because i need to reproject data first . result writing 1000 record takes around one minute . also resources of server are almost taken by fme engine

Cloner, duplication issues after 10,000 rowsMy issue is, my 'source' dataset (6,600 rows) needs to clone each single row 54 times, example - Row '2' is cloned 54 times so the 'output' has 54 identical rows of '2' (to then later be transposed..etc..); I have noticed once the completed 'Output' dataset reaches 10,000 rows it starts again from the top (row 2 of source again), so row 2 has 54 correct clones and then it repeats again at 10,002, 20,002, 30,002 etc......  The issue: Original row 2 repeated again at row 10,002    Simplified set-up:

Hi,I have 2 shapefiles. One file contains road names and another contains locality name. In Road name file the names contain Locality names as well. is there any way I could identify if the names of the locality file. is available in road name file Please note that the words may not be exact. Here the reference file is locality and the target is road file. Any help is well appreciated. Thanks in advance

Input: Several .Las and one SHP file with several segments. Objective: trim the .LAS using the shp segments. Could exist more than one segment covered by the same .LAS. Buffer 0 and square.Output: .Las trimed by the shp file segment and with the SHP file segment attribute name

I am trying to label a grid I have created, the Y axis should be the elevation and the X axis is the station along the centerline.I have the above grid writing to model space in AutoCAD, I think I can get the labels on the X axis but the Y is proving more difficult here is what I am trying to do. See below.

Hi! I've been struggling with this task for a while now and need some help. I have a set of 2D lines (sewage lines if anyone is interested), with a "_lineID" attribute. I also have set of known 3D points on those lines. Some are on end nodes, some are on a vertex. These points also have the corresponding "_lineID" attribute.  Now I want to use these known points to get the lines into 3D, interpolating any line vertices in between which doesn't have a known height. However, I'm having problems with this.I've tried to implement a NeighborFinder with a Group By: _lineID to help where there are points located in the same XY position, only differing in height (see attached screen shot below - the yellow dot is actually four points in the point file, each with a different "_lineID").  This is followed up by a 3DForcer. This part works fine, but I can't manage to re-build the lines

I'm trying to create a multipage PDF with one map for each "delområde" (=part of area) in a city on every page (along with text information later as well). My problem is that both map extents and text do not fit in correct in the frames. I want my map extent to fill out the whole frame as defined in PDFPageFormatter. This is probably an easy task but this is the first time I'm working with pdf's in FME so I feel like I'm missing out on something. As far as for the text, I just want them to be centered in the frame "Delområde". The text is created with TextAdder from the same data as the map extent, which means it still has the geometry and therefore I guess that they are spatially distribuated across the page according to their geometry. Thanks for any help!!

I have a workbench that writes three mapinfo tables to a folder on one file server which I then want to filecopy the mapinfo tables to a folder on a different file server.I think I've got it to work, but I wanted to confirm.I use three FeatureWriters to write the mapinfo tables to a folder on the first file server. Then all three FeatureWriters go to a single FileCopy transformer.The parameters for the FileCopy are;Destination File Copy Folder = folder on first file serverfilecopy_source_dataset = folder on first file serverfilecopy_dest_dataset = folder on second file serverfilecopy_dest_filename = <blank>Is this correct?I have the address of the first file server in twice, once for the Destination File Copy Folder and again for filecopy_dest_dataset. Do I really have to enter this twice?filecopy_dest_filename is blank, which means I get a red arrow. But it runs anyway. Should I really leave this blank?

Hello. I have a b/w raster with only one band but in each band there are 255 palettes with a RGB combine each one. Is it possible extract each combine like a RGB combine value?Thanks a lot.This is the example of the issue.

Hi guys,Is it possible to extract a list of PDF document path and filenames from an O365 Sharepoint folder as you would with a normal network drive?? FILE/PATH Transformer Eg, Date, name, File Location, etc....I can't seem to get this to work with a copy of the share URL for the folder. Maybe there's another way. Thank you.Tim

I have a set of lines which need to be combined. For that I use the LineCombiner. Some of the resulting lines are self-intersecting. That causes problems later in my workspace. A GeometryValidator can correct self-intersections, but is there a way to prevent self-intersections from occurring?In the attached file are some lines which result in self-intersections.

Hi all.This is occuring on FME Workbench 2019.1.I'm using an HTMLReportGenerator to create a table that should have 10 rows. However, I get the 10 expected rows, plus many more that simply say "None." (see attached photo). The 10 features come from a SQLExecutor and I've checked the output with an inspector and have confirmed that there are only 10 rows. The HTMLReportGenerator output isn't very telling, but here's a snippet of where the "None" values begin:             <tr>               <td>Point Loma</td>               <td>108</td>            </tr>            <tr>               <td>None</td>               <td>None</td>            </tr>I've tried replacing all instances of<tr>               <td>None</td>               <td>None</td>            &lt

Hate to be vague with my question. It's quite possible the solution lies outside of FME, too.I have inherited a large workspace with multiple SQL Creators that use ODBC connections. There is a database name listed, and under 'Parameters' there are credentials. There is a SQL statement. Neither tables nor dataset sound familiar.So I have no idea what this actually connects to. There is no way for me to find that through FME, is there? I'm thinking this was either setup through DSN but I haven't located a file, or another way. Any insights would be helpful.

Have data in a non-spatial SQL database stored in a field titled "WKTPolygon" with geometry structured as shown below:MULTIPOLYGON (((257187.77487182617 252016.49029541016, 257197.35565185547 252041.80303955078, 257216.97064208984, etc etcTried all the suggestions from google searching and Geometry Replacer creates lots of individual vertex points for the polygon geometry, but not actual polygons, and all the others error on the first record. Cheers. M