Transformers

Is it possible to get the minimum pixel value, per pixel, in a multiband raster? Rasterstatisticscalculator seem to only do single bands. But what I want is to find the minimum value of a pixel in a raster of 20+ bands.  Thank you

Hi folks,In my situation, I am using JSONExtractor but the JSON queries differ between the testing and production environments. Rather than creating and maintaining two separate FME scripts, I prefer to define the target attributes and JSON queries in a database. This way, the correct configuration is used based on the environment's database.However, the challenge is that multiple rows of configuration records are retrieved (with target attributes and JSON queries as table columns). Is there an example that shows how to convert these database records and assign them to the JSONExtractor in a generic way?Thank you very much!

How to assign RED colour to this cell in final output of EXCEL file. Because TESTFILTER have filtered this Column, whatever Rows are there, irrespective value inside the cell i would like to assign RED colour to the CELL marked with a Blue circle inside final excel file,     this is default OUTPUT  This is how I WANT 

We’re currently experience FME 2 minute+  freezes when we add an Esri GDB reader to a workbench, then press the ellipses to browse to the location.  This only happens in the dialog if we have selected Esri Geodatabase (File Geodb) as the Format.  We have found a work around of pasting the GDB path into the dialog box but we still experience a 30+ second pause when we hit Parameters/Tables.  This takes a substantial time to load. The issue is decreased when a gdb reader is added to a brand new workbench.   

Hey there,I’ve been struggling with a geometry problem. Here’s the thing :)I’m merging two datasets of building polygons. Both come from SDE geodatabases and both appear fine in Esri ArcMap and ArcGIS Pro.When I put theses geometries through a PointOnAreaOverlayer, some polygons, when written to a file geodatabase have weird behaviours in ArcMap and Pro.Their contour draws OK but they don’t fill ! 🤣 The way I solved the problem was by using a GeometryExtractor before the PointOnAreaOverlayer and GeometryReplacer after it. To me this is weird, eventhough I know there are problematic geometries in there. Besides, I tried to solve the problem with a GeometryValidator but that create many more errors. 🙄 If you have any insights about this, I’ll be happy.

I am trying to dynamically join a bunch of datasets to a lookup based on the layer and a specific attribute name and attribute value. I'm currently doing this with an attribute exploder to get the attribute name and value, but the amount of features it's creating is causing a problem when I come to spatially join it to a feature class using a spatial relator. Any suggestions?

Hello,I’m trying to connect hundrets of feature types to different transformers (see screenshot). Connecting them via “Feature Type Connections” window only works if you have a clear mapping/names for your input ports. Connecting them by hand is way to slow and error-prone.I’m sure there must be a better way. Many thanks in advance.

hello experts,I am trying something that to some of you may be quite simple so I hope one of you is able to help me out.All i am trying to do is to append/add the value cnt from the inlinequerier to the existing excel file.I am trying to write the cnt value into the count_of_errors value where the incoming feeder name is the same as the destination one (in excel file).thank you,fb

I am trying to decode attachments from my layer in ArcGIS Online into a JPEG, and it keeps failing. I tried the workflow in this article (using BinaryDecoder then go into RasterReplacer), but I get an error saying BinaryDecoder (TextEncoderFactory): Invalid Base64 character '137'. Next I tried the workflow in this other article (using just the RasterReplacer) and set the format to JPEG / JPEG2000. Doing that results in the records being sent to the rejected port. With just the RasterReplacer, if I set the format to PNG I can get the images to come through, but I need a JPEG in order to write it to a Geospatial PDF.  Is there another step that I am missing, or some other way to write the attachment to a pdf?

I am creating some attributes dynamically, which are then present but unexposed. I will not know the names of these attributes in advance. How do I expose them so I can do some downstream processing with the attribute values? I can’t use the AttributeExposer since I don’t know the attribute names in advance.

I have a 3D buffer that I want to clip with a 3D object. If I use the 3D clipper then it will be only clipped in width, but not in depth. Any solution for this problem? 

Hello,I have the JSON string format like this “[[{"name":"Column1","value":"Value1"},{"name":"Column2","value":"Value2"},{"name":"Column3","value":"Value3"}], [{"name":"Column1","value":"ValueA"},{"name":"Column2","value":"ValueB"},{"name":"Column3","value":"ValueC"}]]”And I would like to convert it to table like:------------------------------------------------Column1 | Column2 | Column3Value1    | Value2     | Value3ValueA    | ValueB    | ValueC Is there any transformer can help me to do so?

I’m trying to dynamically add a suffix to all attributes in two Excel files. The suffix will come from the last 10 characters of each Excel file (fme_basename), which is the date the file was produced. I have not been able get this to work using the BulkAttributeRenamer. When choosing the Action “Add String Suffix”, only constants appear to work. I’ve tried using the Text Editor to dynamically create the suffix in the String dialog. I’ve also tried creating the suffix beforehand with an AttribuiteCreator and choosing it for String. Neither work. I’m using FME Form 2023.2.0.0 (Build 23764). Any insight or advice?

We are trying to set up a nightly read of two separate folders in a OneDrive location to get a list of the files in the directories.  There are several thousand files in each directory.  Sometimes the routine will run and report less than 500 records and then when you immediately run it again it will read all of the 5,000+ records.Is there something I am not aware of on the OneDriveConnector that would be causing it to give such wildly differing results.  I am so accustomed to consistent, bulletproof results when running FME routines that unpredictable, inconsistent results is quite disconcerting.We are needing to write an inventory of files to SQL Server to use for linking in a GIS system.

I have got an excel sheet and there are some cells with just colour and i don’t wish to include them for analysis purpose / output . Without any edits in Excel sheet (eg. add some kind of numeric or standard text for colour cell etc.) i wish to remove or exclude. I also don’t wish to depend on any other column or cell value to filter rows with ORANGE colour cell  I WANT to remove / exclude entire ROW that has yellow colour in cell in Column NCR Ref   

Hello everyone,please, I try to solve one issue, that Im not clear, if FME is able to do that. Is there any way how to migrate data from VPTK (ESRI´s vector tile package) to PBF file? Thanks a lot!Lubo

Is it possible to, if I have two point datasets that both intersect a polygon dataset, filter out the points that both intersect the same polygons ? I was using spatialrelator but it only takes one point dataset at a time; i want to see which polygons are intersected by both point sets at once. Hope that makes sense. Please helpme out, thank you!

Hi All,I’m having some issues to filter raster pixels by the band expression using the RasterExpressionEvaluator tranformer,What the expression to select the pixels with the following band combination B(0)=64; B(1)=128;B(2)=104? I have used the following settings but hasn’t worked: Any ideas please? :)

I’m wondering if there is a way to add vertexes (point) to polylines at a certain distance. Lets say I have a .shp layer with several polylines. I also have a table with “errors” that have occurred somewhere on these polylines. The table have the following attributes:Column 1: Line name (containing the names of the polylines in my .shp layer)Column 2: Distance measured from XXXX (containing names of stations that connect to the polylines, this is where the distance is measured from)Column 3: Distance (km) So basically i know the exact point from where the distance is measured from, I know which polyline the error has effected, and I know the distance. Can I automatically map this out? 

Hello, I want to know how to use PointOnAreaOverlayer for a layer with more than 1 polygon.I have a polygon shapefile for Canadian provinces and a point shapefile for Canadian addresses. Both have the Province name attribute.I want to check if all points that fall in a polygon have the same name as a polygon. For example, I want to check that all points in Alberta have the province name, Alberta. I used the Grouped By Province name, but it did not work.I appreciate your assistance with this transformer or any suggestion for this test. 

Here’s the process I’m trying to implement:I have a scheduled job that backs up a SQL database weekly. I’m using FME form/desktop to drop that .bak file into an FTP. I want the file I upload to have a dynamic date (date when the job runs and drops the file). I’m not sure how to go about this step.  

I am basically doing AttributeValidation but am looking to find values that are blank or empty. Looks like I can't look for blanks or empty's within the AttributeValidation transformer. So, right now I have a testFilter that is checking each field if it is blank or empty. I am using a TestFilter because then I can specify each of the fields that I want to be checked. The problem is that if one record goes through the tester and on the first test we find out that field is blank, then I believe that same record will not go through the rest of the tests. I need to know each field is blank, not just the first one. I am looking for a suggestions on how to do this efficiently. I am basically running a QC process on a large dataset. We have a bunch of business rules that need to be followed. So I am setting FME up to check all those rules. If a rule is broken, then an email will be sent to the person that introduced the error and then they can go back and fix the error. So this one st

I would like to count the rows in a (Oracle) database table and then write that row count to the Translation log.This is so that I can quickly compare the row counts of two tables against each other (as a quick way to determine if an update has occurred)I can use SQLCreator to count the rows of the tableSelect count(*) as COUNT from TABLEThis places the count as a value in a column that is output from the Result of the SQLCreatorMy question is, how can I write this value to the Translation Log?I assume I use the Shutdown Python script. But how does the script read that attribute value?

As I am newbie in FME software I’m looking for a help.I have two sources with lines and I have to point the places where lines are not connected.Is that possible using some transformers? Please look at screenshots and data I’ve attached.   

HiI am currently looking to create a CityGML model of the buildings in a specific area using various spatial data. I have followed this tutorial Point Cloud to 3D Terrain Model with Buildings and obtained an Adobe 3D PDF model of the buildingsBut I now want to convert this model into a CityGML LOD2 model. Is this possible?Since I have just started using FME and am not very familiar with the software, what should my next steps be? Could you provide some useful references? Thanks for your advice😊