Transformers

Hi,I need to denormalize rows into repetitive numbered columns. Here's an example.Here is the normal version as it is in the relational db. Note that the three rows all have the same value in ID_DETAIL field.Here is the desired result. Note that for this one DETAIL, we end up with three groups of columns (ID_MENTION, MENTION, PRECISION).How would one do this in FME ?The number of repetitive groups of columns would be defined by the detail in the dataset having the most mentions (in my example it was 3).I was thinking of some kind of grouping on ID_DETAIL and some kind of "for-each-loop". But any better suggestion appreciated !

Using the circle below as an example. I would like to close the gap, doesn't really matter if it is by snapping or adding a vertice. I have tried both Snapper and LineCloser, but they don't seem to work when there is only one geometry.  How can I connect the start and end points in the example below? I would rather not use the LineCloser of fear of self intersections (real world features are more complex than my example), and the HullReplacer is to slow.   

I have a python script that reads a set of values that we want to expose out of PythonCaller as a list; however, after several attempts, we are having issues outputting the list out of the Transformer. Running the script works outside of workbench, but having issues incorporating the script with FME. Debugging the script and writing to the log, we know the code is calculating the values for the list consisting a several attributes. And, the thinking is we are not formatting the list correctly or defining it. I have attached a simple workbench that contains a slimmed down script that we are trying to utilize to determine how to output a list at all. Any help in this regard is much appreciated. Here is a part of the slimmed down script listing the nested loop we want to use and the List name we want to output:   def input(self,feature):         npts = 3         # do a bunch of stuff with other input attributes to populate D     C = ['X','Y']    D = {'X':[230875

I have a WMS feed that I want to include in an HTML report but don't understand how to to get the HTMLReportGenerator to use it. I have a polygon layer that I group by, buffer it slightly and then user the feature reader on the WMS layer.  If I user the Map option the base map is present but no WMS. Any suggestions?

I have a CityGML file with some attributes containing numbers, but also strings. But for example, the folllowing attribute is supposed to be a float or integer in the 3DTiles format, but is written as a String, no matter what I specify as datatype in the writer's user attributes. <gen:stringAttribute name="DatenquelleDachhoehe">   <gen:value>1000</gen:value></gen:stringAttribute> What could be the reason for the 3Dtiles writer ignoring the specified datatypes?

Hi everyone, Is there and options for i would like to download data from OSM witch based on secondary property of the lines this time show that is it a roundabout or not. Or is there any transformer witch able to find them(roundabout).  Thanks :)

Greetings- I am trying to have a FeatureReader (set to format 'Directory and File Pathnames') fetch file properties for a list of 'Dataset' paths and 'Path Filters' which are incoming Attribute Features but have been unsuccessful in getting it to recognize them as valid. . only 'fixed' values seem to work. I've been through the help and Community posts on this and haven't found anything so far. Thanks in advance for any input.

Hi all,I'm trying to merge two separate excel spreadsheets. Both worksheets have the same names and number of columns. However, they do not have a common primary key to perform a join. All I'm looking for is to append the contents of the second spreadsheet to the end of the first so that I have a single spreadsheet at the end. How can we achieve this kind of merging without using the FME transforms inheriting from the SQL language (FeatureMerger or FeatureJoiner) in FME Desktop?

Hallo FME Community, I have a DWG file with about 100 layers. I managed to reduce the layers to 20 layers with FME by merging layers. Blocks in my DWG result are broken up into their component parts and they aren't one block but several lines. does anyone know how blocks can remain as blocks after transformation.Thanks in advance.  

Hey guys! How can I round to two decimal places while keeping zero on the second decimal place? I would like an attribute with a single digit like 450.199 to round off to 450.20 and not 450.2. Thanks for the advice in advance

I'm trying to replicate an analysis in FME that we have done both Esri and GDAL Zonal Stats tools. It is pretty basic. I have a single band raster layer of percent tree cover spanning the contiguous US. I need to summarize that data at the tract level. I.e. what is the mean tree cover for each tract within the US. I get identical results when doing the analysis with Zonal Statistics in Esri and GDAL. When I conduct a similar analysis in FME by clipping the raster to the tracts (merging attributes) and then use the RasterStatisticsCalculator on the result, I get a completely different answer. 

is there a way I can only display "Translation parameter values" window when I run a process via quick translator ? The background window "FME Quick Translator" somehow is redundand I think since I dont need it.   

Used arcmap to import xml of data schema only from arcsde into a file geodatabase. Using esri geodatabase (ArcSDE Geodb) reader to esri geodatabase (file geodb). receiving error message:An error occurred while attempting to open an insert cursor on the table 'Beacons'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [Beacons]}  

The data needs to output from Row 5 cell A to U. I can see you can use the start position of 5 which works but everything above get's wiped out so I loose the headers. How to I stop loosing the titles and headers from the output in Excel in FME?

Hi everyone,I'm trying to restore a arcgis polygon feature layer (feature 1) (that someone accidently ran a simplify geometry tool on) with the geometry of a backup feature layer (feature 2) from a older copy of the dataset. Problem is that I ONLY want to replace the geometry of feature1 and keep the attributes. The workbench that I build (see picture below) will replace both the geometry and the feature values/attributes of feature 1 Any tips on ONLY replacing the geometry? thanks in advance. 

I'm trying to update/delete from an SDE featureclass using fme_db_operation, The changes are grouped in 4 groups: 2 delete and 2 updates. The Deletes work fine, the first update group (updates both geometry and attributes) works fine.But the the last update group (updates only attributes) does not write data to DB. There is no errors, there is 5 exspected warnings (non existing keys) but for the rest of the +70.000 records there is no indication of anything is wrong - except the data is not updated.Best regards  

i need to reprojection from (wgs1984-utm-zone39n) to (KSA-GRF17 )but don't find KSA-GRF17 in coordinate system?

I want to merge small polygon (<0.01) to adjacent large polygon same the same commune. Could you tell me how to make it? Thank you

The workflow looks like this: I'm downloading a .zip file via an API and unzipping it using the ZipExtractor. Connecting the ZipExtractor 'File' output to a Feature reader, I was hoping to be able to upload the gpkg-file from 5 different output ports to 5 tables in a postgis database. This works fine if I specify the geopackage file manually in the 'Output' section of the feature reader. Is there a way to use a transformer or to edit the FeatureReader to make it read the output ports directly/automatically from the gpkg-file in the folder the ZipExtractor has unzipped?  Thanks!  /Alex

Hello Sir/ Madam, My goal is to run a batch processing so that I can count all the attributes in each input excel file in a particular folder. Then, I would like to output the result in a single excel file. Is it possible? My caseData - 2 excel files: A.xlsx & B.xlsxWorkbench: "Value count" by using statisticCalculator transformerOutput : 1 single excel file Problems that I encountered:1) I try to run the "Batch Deploy" in the workbench and it returns the result files indivdually. Can I group all the output into a single excel file? 2) In my workbench, May I ask how can I count all the attributes values? The "StatisticsCalculator" must defined the attribute name in order to do the counting. However, I would like count all the attributes in the excel file. It is because my input excel files may have slightly different attribute names in it. Thank you very much. Zachary

Could anyone help me understand why I get the following error. It currently occurs at a junction but if I replace the junction with a normal connector then it just occurs elsewhere so it doesn't seem to be related to the transformer. Junction_139_Output Feature Recorder -1 2147615843 (RecorderFactory): File C:\\Program Files\\FME\\metafile\\ffs.fmf could not be openedFile C:\\Program Files\\FME\\metafile\\ffs.fmf could not be opened I've tried running FME as an administrator in case that helped but got the same result. I also googled and found a similar issue but that related to just \\.fmf file and was apparently caused by databasejoiner which I'm not using. I've also uninstalled and reinstalled FME. If I disable feature caching then the workspace runs fine but that means I can't debug anything unfortunately.

Hello!  I have a CityGML dataset consisting of MultiSurfaces - atleast that is what FME tells me:  an example of a surface:  I would like to extract the surfaces' triangles, so each triangle has its own feature/record in the output.  So far i have tried 3 methods: using the deaggregator. Looks like it didnt do anything. using the geometryPartExtractor. I have extracted the "IFMEface" geometry-type from the surface, but this just looks like original geometry, where all triangles are one geometry. Afterwards i added another geometryPartextractor and tried to extract the IFMEPolygon - but this seemed to just remove the triangles from the geometry. using the Triangulator. Using the triangles output, input these into a geometryPartExtractor where you extract the newly created faces. This worked somewhat, however the triangles it made do not always correspond with the original triangles. the example from above gets a new triangle: If possible i would like the original triangles

If I have a date field formatted as month-day-year is there a way to retreive just the month and use it in a tester? I want the user to input a month and then if it matches the month in the date field it will select all of those records. The data is in a geodatabase if that matters.

Hi friends, I have an ESRI filegeodatabase with 3D multipatches. I want to cut out areas there. I have tried this with the clipper, but no result. Not only that, but I also tried extruding the clip extension. But also without result. Does anyone know the best way to clip this? Thanks!

I want the user to be able to select the tables to be read from a geodatabase. I added the reader using the single merged feature type. This gives me a list of tables for them to choose from. What I want to happen is depending on which tables are selected, it will output to a schema mapper which reads the tables and writes to a geodatabase. So, I was thinking I would want a tester but the tester doesn't have the ability to show the tables. Anyone have any idea of how this can be done?