Transformers

I have data coming in from an instrument. It contains the readings for gasses like oxygen and H2S.  I am trying to create a report to highlight the highest value in a given hour on a given day. With the table below: Instrument 1 | 10:00 AM | March 1st | Unit ABC 123 | H2S 10 ppmInstrument 1 | 10:05 AM | March 1st | Unit ABC 123 | H2S 5 ppmInstrument 1 | 10:10 AM | March 1st | Unit ABC 123 | H2S 0 ppm...Instrument 1 | 10:00 AM | March 2nd | Unit ABC 123 | H2S 10 ppmInstrument 1 | 10:05 AM | March 2nd | Unit ABC 123 | H2S 15 ppm... I would want the report to show me the following,Instrument 1 | 10:05 AM | March 2nd | Unit ABC 123 | H2S 15 ppmInstrument 1 | 10:00 AM | March 1st | Unit ABC 123 | H2S 10 ppm because those values are the highest gas reading for each hour, (10 AM as a record, 11 AM as another etc) on each unique day. I have tried the statistics calculator, but it doesn't allow you to accumulate the other attributes, or allow you to find unique fields to 're-merge'

Hi,I have a process where I have identified the closest two points to each point (using the NeighborFinder), then created polylines from the source point to each of the closest points, using the VertexCreator (Add Point, closest candidate x, closest candidate y). The process runs and seemingly creates the lines (attribute table shows the features), but the lines aren't visible in the inspector nor when I write them to a .gdb. When I click in the area where I know there is a line on the inspector, the attribute table selects the record - but the line isn't visible? Has anyone experienced this before?

I've tried following the steps here: Article Detail (safe.com) but my kmz folder name doesn't appear in the "Select Feature Types" dialog

Hey Safers ... Long time listener, first time caller. Go easy!  See below, I'm iterating over rows in a CSV, using these to build ArcGIS Map Server URLs, pulling features from the services, and writing them out to GDB (eventually SDE) feature classes.  I use the Map Server layer numbers to build my URLs, in turn these layer numbers are assigned to my schema and feature_types, and eventually become the feature class names in my GDB.  Has anyone got any pointers on how I can use the more friendly layer_name values to name my feature classes? Thanks in advance! Sam  

Hi there,we have a workspace where we check with a HTTPCaller, if an URL has data to download. This workspace works perfectly in FME Form.  If we notice, that there are no data available, we want to become an E-Mail in order to react on time. We have created an automation in FME Flow with an E-Mail-block.  Now we do not know how can we make the match: No data to download (FME Form) -> Action failed way in FME Flow in order to send the mailData to download (FME Form) -> Action successful in FME in order to log a message how can we make it? Thanks a lot in advance

I am creating the desktop version first but it will eventually be published to FME Server so the specific file choice would need to be done using a user parameter.Ideally, I would like the generic reader to be able to accept any of the following file formats: feature class, shapefile, GeoJSON and CSV. I have created a published user parameter for File/URL which would allow the user to locate the file they wanted to run through the workbench.Currently, when I try to add this user parameter in as the Dataset for a generic reader, I get the following error:Workspace generation failed. Parameter file was C:\\Users\\********\\AppData\\Local\\Temp\\FME_1697209596703_9204. I have also set up a workbench where I tried filtering to feature readers for specific formats e.g. feature class would have it's own Feature Reader where the Format is: Esri Geodatabase(File Geodb) and the Dataset is still my user parameter. However, in this example, it needs to know the name of the feature class(Feat

Hello everyone, is there any way how to generate next letter of alphabet? E.g I have feature with value "A" and I wanna generate next letter in alphabet, so letter "B". Is there any function for that? Thanks a lot! Lubo

Hi, Is it possible to upload an entire folder from a local PC to Flow Shared resources, via server/automation app? I know that single files are able to be uploaded, but I was hoping my workflow would go like this: User uploads file via web app. It is stored in Shared resourcesSeparate workbench uses a Path reader on the file, gets all .shp files and performs ETLI can't see any other way to do it, other than the user having to upload 20 different shape files via the app interface. I get this warning when using FME copy writer, with s published parameter of 'filecopy_source_dataset':File Copy Writer: Feature contains an invalid source dataset 'C:\\Users\\myuser\\Documents\\Development\\FME\\UPLOADFOLDER'. No file operations will be performed for this feature Many thanks, Sam

Hello everyone,Is there a way to drap a 2d surface or polygone into a 3d surface (like in the picture joined). If there is in which format do we need the surface and polygone to be? Thank you in advance

I am using a SchemaScanner to prepare a dataset for dynamic writing to a PostGISWriter. How do I write to the columns for PrimaryKey and Geometry in an dynamic environment?

I want to turn my vector layer into a raster layer and then back into a vector layer to simplify it. When I used NumericRasterizer, I grouped my layer by category, but when I convert it back to a vector layer, it's not working. When I tried to rasterize it without grouping it, it worked fine, but I lost the attribute I was interested in.

UPDATE: Managed to figure out what went wrong in my comment below the main post (TLDR: Used the wrong transformer and field value from my dataset) Hi, so I'm trying to convert my annotation layer in my GDB files along side the point, polygon and line layers into DWG. In my screenshot of my ArcGIS Pro instance, you can see the various labels above my polygons.But it looks like only 2 of them passed through to DWG when converted through Workbench.In my current workspace I'm using a LayerTypeField field in the attribute table of all of my layers I wish to converted to sort them into the correct flows (Points, Polygon, Lines, Annotation).Those values are exposed via an AttributeExposer parameter as you can see here:The annotation layers are very basic ones that are created from running Convert Label To Annotations within ArcGIS Pro itself and an additional field added that just contains "Annotation" as text for filtering purposes in Workbench (LayerTypeField).  At this ju

I have a point array of addresses, and a line geometry layer of streets, and I need to be able to get the ID of the nearest line to the point that also has a couple matching attributes. What are the best options to consider?

Under path parameters for the reader it no longer has "retrieve file properties" which means I can't access the create date of files breaking one my workbenches. I tried using the filepropertyextractor transformer but its just too slow for the amount of files I need to read. Is there a way to fix this?

Hi everybody! I have tried to remove collinear points without sucess. For example, a square(polygon) but between two vertex I have one or more collinear point's. So how to remove this???

Hello,it is first time ,I use zigzag transformer but I got error .python caller failed to process feature .how could I fix it ?i have used spike remover for the same input lines data and it works great without problem .which transformer is better (spike or zigzag) ?which angle that should I use from your experience ?thanks in advance FME 2021

I have a bunch of points that fall on or near a linear features (routes/roads). Is there a way to use the Locate Features Along Route tool in FME to identify which route those points fall on?

Hello ,i would like to know ,what is the best tolerance value that use in anchored snapper (segment type ) to avoid any problems i have used 0.02 , automatic .it works well for some lines but it make problems for some lines when they are so close or cross eachother .The segment type of anchored snapper make lines to be intersected instead of cross lines . which value that people has experience with segment type always use without any problems ? is there any alternative for anchored snapper segment type that do the same purpose fme 2021 

I have string attributes which contain repetitions of the type ";;;". How to get rid of these, however numerous the ";" are. I also want to nullify the attribute if it ends up being ";" but that can be done with a trimmer afterwards. I also would like to delete other repetitions.Examples"31;31;44" should become "31;44""*3*;*3*;*4*" or "*3*;*4*;*3*" should become "*3*;*4*" "#TH#;#BAT#;#TH#;#BAT#" should become "#TH#;#BAT#"

Hi, I hope someone can help:I have an XML URL.The URL is updated from my reader with different variables. I go through the AttributeManager to stitch together the different URL's I need to go through.I input that result into the FeatureReader When I go the the FeatureReaders parameters and choose elements to match, I see this:If I take the URL the FeatureReader receives as an input and paste it into a browser, it worksIf I take the working URL and hardcode the value directly into the AttributeManager, without any variables, the FeatureReader gives me the same errorIf I paste the working URL directly into the dataset within the feature reader I get access to the parameters and can set the Elements to Match, but that won't make it updateable from the features coming in.To me it seems like I can't use an attribute with the URL as a dataset on an XML URL in the FeatureReader. Does anyone know how to use an attribute calculated from the input data to get the information out of a

Hello, I have a response from one of the APIs I'm using that is formatted as the following example:{ "measurements": { "timestamps": [ 1504377563, 1504378166, 1504378372 ], "waterGround_mm": [ -5032, -5030, -5031 ], "waterNAP_mm": [ -7532, -7530, -7531 ], "validity": [ null, null, 1 ] }}Now, I can flatten this using FME to the following lists:_timestamps{0}: 1504377563_timestamps{1}: 1504378166_timestamps{2}: 1504378372_waterGround_mm{0}: -5032_waterGround_mm{1}: -5030_waterGround_mm{2}: -5031_waterNAP_mm{0}: -7532_waterNAP_mm{1}: -7530_waterNAP_mm{2}: -7531_validity{0}: <null>_validity{1}: <null>_validity{2}: 1Now my idea would be to rename these lists somehow to _list{}.measurement, _list{}.waterGround_mm and so on, and then use the ListExploder to explode _list{} to features. Sadly I can't find a way to properly rename _measurement{} to _list{}.measurement. Also, just trying to explode _measurements{} takes a long time with 30.000 records. Is this the proper way to go ab

Is it possible to set the Cache-Control header using the S3Connector? When I set Cache-Control in the Metadata it changes it to x-amz-meta-cache-control, which supposedly doesn't influence cache control on client requests. My Content-Type metadata changes are working. Is that a bug or expected behaviour? Via Cloudberry   

I current have a workspace reader that reads all of fmw files in a selected folder and use the WriterFeatureTypes to find all names writers in each fmw file being read.But when I run it, it produces errors and warning messages that aren't relevant to the writer (screenshot below).Since I only wish to know the names of the layers that the writers in each fmw file writes to, is there a way to avoid reading other information about the file such as the transformers to remove getting these errors/warnings and improve the runtime?

The data lod-2 is available for public download from the servers of the bavarian Opengeodata platform at: <https://geodaten.bayern.de/opengeodata/OpenDataDetail.html?pn=lod2> here is the direct link to a 2x2 km square that is downloaded as citygml: <https://download1.bayernwolke.de/a/lod2/citygml/704_5322.gml> I have a whole workflow for processing that data, which stopped working without any changes to the workspace. Then i realized that i can not even read the data into a brand new workspace with the same basic error message being shown:'http://repository.gdi-de.org/schemas/adv/citygml/1.0/cityGMLBaseLoD2.xsd' mapped to 'C:\\Users\\mutzh\\AppData\\Local\\Temp\\FME_XSD_CACHE\\fmexsd_1696954419928_14896.xml'Parsing schema document 'C:\\Users\\mutzh\\AppData\\Local\\Temp\\FME_XSD_CACHE\\fmexsd_1696954419928_14896.xml' ...XML Parser error: 'Error at file: 'http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd' line: 126 column: 22 message: unable t

Hello FME Community, I am using a 'StringConcatenator' and a 'Text Writer' to create a text file. I intend to add two separate texts as the header and footer.  Is there a way to add these texts without duplication?