Transformers

Why can't ListExploder see result{} from a reader that reads json with the output of result type array?? I have tried jsonFragmenter but listExploder still does not see result{}.

Hi,I've tried to facilitate using the SpatialRelator with the "Input Ordered" set to "By group". And set the "Group By" value to a common attribute.I sorted both my Requester and Supplier inputs by the same value. But even though the log file shows the expected groups, all groups have no matches (typically "0 BASE(s)").Please advise as to how this functionality is supposed to work.I got the process running by setting "Input Ordered" to "no" (keeping the "Group By"), but I think that this is not as efficient.Cheers.

I tried looking for similar queries but I need some help with this asap. To explain my question further, I have a point cloud with x, y, z and the fourth column is a componentID (after having done connected components) I have a text file which consists of a string of component ID values.I am trying to filter the point cloud based on the number of component ID values in my text file. So, I have a couple of questions.1. I am trying the basic method by filtering the point cloud based on the value of the component but I keep getting the following error PointCloudFilter(PointCloudEvaluationFactory): Attribute 'C1' is specified in an expression but is not present on the feature. Please ensure the feature has all referenced attributesI am not really sure how to solve this. Because if I use an attribute creator to assign values to C1 independent of the values from text file, it works fine. But when I integrate it with text file it goes into error.2. My text file will not always contai

I have HTTPCaller connect to JSONFragmenter connected to JSONExtractor. Are these list that have to be converted?

Hi,I wonder how can I call @Http function with the FunctionCaller transformer?The reason is that HTTPCaller does not support specifying proxy server directly, but the @Http function seems like it supports custom proxy setting.Thanks,

Is there a way to tell an SDE reader to forget the spatial? I can read as SQL Server Non Spatial, but I lose the SDE ST.Area attribute, which I need. However, I don't need the actual geometry and reading it wastes 30 minutes.---- Hoping for an "opposite of Geometry Only".Thanks,Jake

Hi,Faced with having to handle multiple large datasets (5M+ features), I'm looking into whether I can improve performance. I just had one of these dataset crash after 12 hours !The task is matching any source data set (only) spatially with a data set of buffered municipalities, and so there are no common attributes. I.e., no possible values for "Group By". Any source feature could possibly end of in any number of municipalities.Is it possible to get a performance boost under these circumstances ? And if so, how ?Cheers

When using the GridInquest11Reprojector to project data from irish grid to ETRS89 Geodetic the following fatal error occurs "Source coordinate system 'Irish Grid' cannot reproject to destination coordinate system 'ETRS89 Geodetic', either 'Out of Area' coordinates or invalid coordinate system parameters Reprojector: Reprojection failed" This doesn't happen when reprojecting the same data set using the GridInquestReprojector. Only the first pair of co-ordinates appears to be projected when using the GridInquest11Reprojector as per the extract from the error log below.Geometry Type: IFMELine Number of Coordinates: 78 -- Coordinate Dimension: 2 (-6.5027536642668426,53.275450616997503)(299914.2325,226047.6043)(299912.3574,226060.10490000062)(299909.2323,226072.6055)(299909.8573,226083.8561) (299911.1074,226098.23169999942)(299920.4828,226106.9821000006)(300232.9973,226190.1109)(300303.6255,226166.9849)(300321.7513,226161.9846) ...Skipping coor

Hi there,I've searched a few threads on here about calculating percentages, but nothing seems to quite summarize what I'm looking for.I have several polygons, each containing an attribute of "TotalKm" and "MinorKm"The "MinorKm" represents roads inside that are of a lower class or quality.I simply want to calculate the percentage based on the "TotalKm", like this example:MinorKmTotalKmPercentageKm156025%15020075%I tried playing around with the ExpressionEvaluator to do this, but I could't quite create the correct expression for this.Thanks in advance,

Most of our ArcGIS projects are in a custom projection based on NAD83 2011. I cannot find a transformation for converting the data to EPSG4326 (WGS84) for export to kml files. I added the custom projection to the MyCoordSysDefs.fme file and it is reading the parameters. Anyone else working in the 2011 datum trying to export to KMLs? We are seeing a shift using the older NAD83 to WGS84 transformation, how do you work around that problem? Did you have to create a custom transformation?It doesn't help that ESRI refers to the datum as GCS_NAD_1983_2011 and FME has it as NSRS2011. It appears not able to translate those two.

Hello everyone,I'm stuck on something in FME and looking to you all for assistance.Little background for the following example is I work for a Large Utility Company and working with data in an electrical system which is Points and Lines:Here is the the basic description of my problem and what I am looking to achieve and I have the workbench built (or did until I ripped it apart trying to solve this).I have a LINE object (Primary Conductor) being filtered by an Attribute (Circuit) and have multiple different features (all points, representing the different electrical devices) which have a Circuit field but in some TiePoint cases the Circuit field could be different.Therefore I am running a SpatialFilter on those points that touch the conductors and after it runs through the rest of the workbench produces an object named by circuit and the type of device it is.My workbench accomplishes everything I need it to EXCEPT the points that join between two different circuits (Lines with diff

Hi,I’m trying to transpose the following table from SQL Server:KriterieTestparameterVerdi 1Verdi 2Verdi 31UNIKEnToTre2STADNasjonal5PROD123Into this table (first row as column name):TestparameterUNIKSTADPRODVerdi 1En1Verdi 2To2Verdi 3TreNasjonal3Kriterie125Using this article, I’m able to transpose the table into (column name like A-G): https://knowledge.safe.com/articles/31701/transpose-a-table-using-fme.htmlBut for further use the column name must be the first row, not A-G.How can I set first row as column name? I’ve tried using the AttributeCreator with values from a second list, and exposing the dynamic attributes afterword’s, but I can’t get it to work.. Attribute name from list example: New Attribute = @Value(_testpara_attri{0}._testpara_value)Attribute value = attrs{0}._attr_valueWhere _testpara_attri{} is the list with column names, and attrs{} is the list from the transpose routine. Workspace:

Hi, I want to do a point on polygon analysis and list all the records under each polygon without merging duplicate properties.I’m using Spatial Filter to find the properties within a given area. It’s giving the correct output if I send one record at a time. But when I send all the area records to Spatial Filter it merge duplicate properties (candidates) to a one record.I’ve change parameters on the Spatial filter but failed to get the expected output. Can someone please help me? Area record and relevant properties Area ID Property 1 A 1 B 1 C Area ID Property 2 C 2 D 2 E Expected Output Area ID Property 1 A 1 B 1 C 2 C 2 D 2 E Expecting 6 properties, not 5 properties after merging the duplicated property C.Thank you.

Hi,I have what I think is a fairly simple question. I just want to calculate the average of all the cells in one band on a raster. I am using FME2017.0.Is there a simple way to do this without having to convert the rasters to vectors (points) and then using StatisticsCalculatorThanks

Is there a way in FME to detect if there has been a change in the attributes name or if there has been a new added attribute to a source file how it can be synchonised in writer

Hey folks, I'm in a bit of a trouble. The readout of an xml file gives me an attribute that contains coordinates. The attribute's content is like this: '47.609703,9.858943 47.620427,9.867245 47.613033,9.92076 47.600331,9.930115 47.612142,9.960663 47.61008,9.972698 47.631773,9.980192 47.609703,9.858943 47.609703,9.858943'Please be aware that i shortend the count of numbers.All I am trying is to build a polygon with these coordinates to write an Esri shapefile.The PolygonBuilder/AreaBuilder won't help because it needs polylines to work with. Thanks you so much,Ed

Hello, I've tried looking into this and I'm pretty sure I know the readers and writers to use but the middle bit seems to be stumping me. Put simply, I have a folder with 800 files in it. I have a list of about 200 files which reside within the aforementioned folder.I'd like to copy and paste only the files contained within the list into a new folder.Any help would be greatly appreciated!

Hi,For a given 2 lines (line_id1, line_id2), I should do LineOnLineOverlayor and then lengthcalculator.After that I want to have the accumulation of length of the new segment of Line_id1.Ex: length_accumulator of the first new segment = the samelength_accumlator of the second new segment = length_accumulator + lengthAnd so on.I’m using Counter (to have line_id1), then LineOnLineOverlayer (generate List line_id1_List) and finally AttributeCreator (length_accumulator).What should I do to calculate the length_accumlator (I can not use length between coordinates because I have curve and polylines)?Thanks

Hi together I get a lot of polygons and some of them have redundant vertex point coordinate!!! How can I remove the redundant points in this polygons? Thanks Zoran

I have a point cloud and am wanting to create a 3D solid from the extents. I have been able to produce a solid like this below with help but just wondering if there is a way so that the solid is created like the first image attached with the solid that I require very roughly outlined in red?Any help greatly appreciated

Hello,I'm trying to create a kml-file using the xml-templater. In the kml file I want to visualize points and Lines, something like:<Placemark>  <styleUrl>#Icon</styleUrl>   <Point>  <coordinates>{fme:get-attribute("rw_wgs84")},{fme:get-attribute("hw_wgs84")}</coordinates>  </Point>  </Placemark> <Placemark>  <LineString><coordinates>{fme:get-attribute("_coordinates")}</coordinates></LineString> </Placemark>But I get an syntax error (missing comma between the Placemarks)?What Am I doing wrong? How can I create a template for different placemarks?Thanks for your help,Isabell

Exporting a Database in 12c , the SRID is set to null , is there a way that FME can update all SRID to correct coordinate system within FME , would it be Feature class by Feature class or can it be doen for the whole Schema ?

Hi Guys,I hope I explain my self clearly.My Problem is: I have a point dataset and a line dataset. What I want to be able to do is find the point that is the closest to the start and end node of each line object and display it in a csv file etc.The lines could have multiple vertices in them but I only need to know which point is closest to the start and which point is closest to the end.Both datasets are shape files.Is there any way this can be accomplished?so the output would look likeline_idline detailsstart_node_pointend_node_point1234sdgsgfg9876541234565678sgsfhdfhd546214748565

Hello, any datetime expert out there? I have a dataset in yyyymmddhhmmss format in utc time. Now I am trying to convert it to local time with the consideration of daylight saving. I know the newest version of FME has features that support advanced datetime conversion, but still really confused on this especially with daylight time saving. Before, I have a user parameter to ask the user to manually choose the UTC offset. Now I am trying to upgrade my workspace so that I can get rid of this and have the FME detect my UTC offset automatically. Any ideas? Really appreciate it!!!