Transformers

Hi,I would like to filter out whether a certain value appears multiple times in either of two fields. An example:ID1ID2Desired action1_22_1keep1_33_1keep2_11_2discardCurrent attempts have either given me the rows which don't ever appear twice across the two fields, or a full list of those that do appear twice across the two fields. Is there a way to filter out duplicates looking at both fields?

I have a table that I'm downloading from an FTP site as an attribute (all data is in a single cell) that I need to inject into another part of my workflow as if it were coming from a csv reader table (data is broken out into their respective cells). I've been able to get the data broken down into it's indexed components but can't figure out how to reassemble them back into a table. I've looked at the transpose demo video but I'm not sure how to handle I've attached a workspace that shows where I'm at as well as an image of what I'm trying to replicate. Any help would be very appreciated! :)

Is there a way of doing the same thing as in ArcGIS Raster zonal statistics ? I have a 1 billion cell raster (whose values are comprised between 1 and 5) on which I want to overlay a 3000 polygon layer. I am looking for the number of 1, of 2, of 3 value cells, etc. in each polygon. Coercing my raster to vector (polygon or points) would produce a too big dataset so I am trying to avoid it. Any ideas ?

I have a dwf file with points and text (as line features). I'm trying to convert the data to a point shapefile and add the line text to the point as an attribute. In the image below the text '7086 PM' is actually just line features that make up the numbers and letters. Is there anyway to convert this to a shapefile and append the text as an attribute? If needed, I can share the dwf to get a clearer picture of what I'm trying to do.

As shown in the attachment, I am looking to replace the <missing> values with the value located above it. For example, I want rows 44 to 48 to contain the value 2nd st.

How can I find solitary pointobjects? I have two datasets with pointobjects. From both datasets I want to filter the objects which have no other near object within a specific distance. And then I want to match those solitary objects from both datasets "if the solitary objects from the seperate datasets are within a specific distance from eachother. How can I do that?

Hello There I am traying to read this bellow wfs , I trayed all combination on configuring the wfs reader but still giving me the error ( Failed to obtain any schemas from reader 'WFS' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information)twe could open the URL on browser and also we could read it on ArcMAPhttp://webgis.eamana.gov.sa/arcgisnew/services/BASEMAP/MapServer/WFSServer?request=GetCapabilities&service;=WFS

Using a GIS system that doe not like import of curves. Using multi-vertex line, but wondering if anyone has idea how to make more dynamic based on arc angle and length to reduce block look of curved line in the GIS. Not sure if best to use multiplier (angle * length) then factor to provide reasonable distance between vertices. Aware that shorter length but greater angle will probably require closer vertices than longer length and less angle combination. Just not sure how to quantify this.

Hello,I have polygons that are constructed from lines using line closer and area builder so i could add some attributes from other features. Now i need to deconstuct back to lines with those attributes. Unfortunately i had no luck searching the forum for related issues. Any help?

I have an attribute that contains GML geometry that I would like to convert to WKT geometry but its not going so well. For the easy geometry in these files a simple GeometryReplacer does the trick and with a simple stringsplit action in python this is also converted without using too much resources. <?xml version="1.0" encoding="UTF-16"?><stufgeo:kruinlijnBegroeidTerreindeel xmlns:stufgeo="http://www.geostandaarden.nl/imgeo/2.1/stuf-imgeo/1.3">    <gml:Curve srsName="EPSG:28992" xmlns:gml="http://www.opengis.net/gml">     <gml:segments>      <gml:LineStringSegment>       <gml:posList srsDimension="2">161274.467 453784.372 161277.253 453785.924 161279.958 453787.131 161280.921 453787.508</gml:posList>      </gml:LineStringSegment>     </gml:segments>    </gml:Curve>   </stufgeo:kruinlijnBegroeidTerreindeel>Using stringsplit or Python the result would look like this:LINESTRING(161274.467 453784.372,161277.253 453785.924,16

I have a set of records. Im using Modulo counter to count maximum 7 records. Now, I need to assign a unique value to each set of 7 records. For example I need below output,ABModulo_countUniquexyz1abc101xyz2abc211xyz3abc321xyz4abc431xyz5abc541xyz6abc651xyz7abc761xyz1abc102xyz2abc212xyz3abc322xyz4abc432xyz5abc542xyz6abc652xyz7abc762xyz1abc103xyz2abc213xyz3abc323xyz4abc433xyz5abc543xyz6 abc653xyz7abc763

Hi guys,I am currently facing a problem when trying to run a workspace for a particular layer. This workspace works fine for other layers except one.Could you advise us on what could possibly be the issue? I believe the layer is valid because we are able to manually copy the layer into ArcCatalog and we are able to view the map/image."Truncating table 'schema.xxx' Required columns 'OBJECTID, ' not specified for predefined table 'schema.xxx'. Using Definition from Database The business table 'schema.xxx' will be modified to have the layer 'SHAPE' added to it. As a result, the table will be able to store geometryError creating spatial column 'SHAPE' within table 'schema.xxx'. :SDE_ERROR_CODE(-96) The user must be the table ownerDestination Feature Type Routing Correlator(RoutingFactory): Error creating spatial column 'SHAPE' within table 'schema.xxx'. :SDE_ERROR_CODE(-96) The user must be the table owner"T

Good Afternoon, My Objective Build a simple model that will convert an elevation model that is using EGM2008 (Orthometric height) to one that uses Ellipsoid WGS84 My Test Case I'm using an Airbus WorldDEM Horizontal Coordinate system: GCS WGS84(G1150) Vertical Datum: EGM2008 Location: Rio de Janeirohttps://www.intelligence-airbusds.com/worlddem-sampledata/ My Problem: The GDC file i created does not seem to work as the CsMap Reprojector Library does not contain provisions for setting WGS84(G1150). It only allows you to use LL84(EPSG 4326) which is the original version of WGS84.   So, i ignored the WGS84(G1150) and built the tool using LL84.  My Procedure (This would be the same for the regular FME 2018 Desktop)***************************************************************************************************************If you don't have ArcGIS Pro, you can download the same vertical shift files from the following location to test my methodology with FME Desktop.http:/

For documentation only as this one is allready reported. (C137061) Like to share as this one took me by surprise, in production.Aggregates split by a clipper can't be written to geodatabase featureclass using GDB API writer. No issues when writing with GDB ArcObjects writer. This only occurs when input geometry is an aggregate and the result is a splitted aggregate.Found in 2016.1.1.0 Was able to reproduce in 2017.1.2.0 and 2018.0.0.3Workaround is to deaggregate and aggregate again.  

The TopologyBuilder produces this useful piece of information when generating new nodes on data that is not clean:Completed intersection processing, phase #2. 3 new nodes were generated among 294792 intermediate linesIs there any way to access this information other than using further techniques and if not, two things:Can this be raised as an enhancement request?What would be the most efficient way of finding these new nodes on a large dataset (4.5 million line features)?I am using FME Desktop 2017.0.1.1Thanks!

I'm creating a collection of line features from a GPX file. I've processed the points from the file to calculate things like slope and speed at the various locations. I've then generalized these slope attributes into Uphill, Downhill, and Flat. I want to use these as Connection Break Attributes to segment the LineBuilder output. However, upon doing this I've realized that there are distinct gaps in the track as there is no line connection between the vertices that start/end a line that has a different Connection Break Attribute. Is there a tidy way to attach these together?

HiI have a set of CSV files from http://nrfa.ceh.ac.uk which specify a national grid reference for the location of gauging stations - e.g. TQ0993167056 for "Thames at Walton" (station ID 39121).I'm trying to read in the text files and create points from the grid references so that I can do spatial transformations, but can't seem to get FME to create geometry objects from the codes. If I had lat and long I would use the vertexcreator but can't seem to find an equivalent that works with BNGAny help would be much appreciatedThanksAdam

I am running a Workspace and after a while it gives an error and as if the memory had burst, is there any way to control memory?

Hello,In one table in my database I have some polygons (lets say covering cities) with their names. In other tables I have some other features(geometries together with attributes).Now I would like the flow like that:1. Pass publish parameter as city name.2. get all features from other tables (for example schools) but only which are inside specified city3. spatial filter can't be (contains) because I also want to have school presented on the attached image4. My idea was to get the central point for each school, then test if it is inside given polygon and if yes then add it to the result.My idea was to do it this way:1. feature reader for cities with filter applied2. feature reader for schools - end now the problem, should I apply the spatial filter here or is it impossbile? Now how to test if the center of given school is inside that city?I don't know how to combine it all together. Thanks for any hints on that. cheer!

Hello therewe have an ESRI geoDB with 244 table there named based on the dataset type, City name and Zone as you see on the attached excel we want to combine them based on the dataset and Zone then use the reproject them in one coordinate system, in order to get all those tables only by dataset nameI did manage to extract the table name and build the excel in order to make groupsAny idea

Hey,If I have a datetime, I'm wondering how I could convert it to a string.

Hi all,Working to parse some sections out of a webpage. I need to associate some values with their heading. I can get the h3 values I need or all the ul or li elements on the page but trying to get just the ul and li element under each h3 to keep them grouped. Seems like using a h3 ul li selector should work but it doesn't return anything. Changing the space to a comma (,) returns all the values not just those ul and li within the h3. I've also gotten the values for the h3 and can get each h3 individually using "h3:nth-of-type(@Value(part_idGEN))" but again trying to get the ul or li element under this doesn't work either.Using FME2018.0.0.1 Build 18295Webpage is https://www.thewindpower.net/windfarm_en_182_gent-zeehaven.php Thanks,Andrew

Hello everybody,I´m trying to solve problem with using REST API on FME Server. All I need is to generate new session ID for every data upload to FME server. Is there any special function to generate new session ID?Now, if I upload new datafile, the FME Server still keeps the same session ID, e.g.:{"serviceResponse": { "statusInfo": {"status": "success"}, "session": "DDDB81451D5F0192DE8292DD71A0EF46", "files": { "path": "", "folder": [{"name": ""}] }}}I tried to use getSession function (meant there: https://knowledge.safe.com/questions/57605/javascript-rest-example-keeps-sessionid.html) but i doesnt work, because it returns still the same session ID. How to generate new one please? Thank You so much for all tips!Lubo

Do you know what's the difference between RGB24 and RGB48? I know a byte is added to the pixel, but what's the real impact on the image?

Hi,I have an FMW file that runs various SQLexecutors and produces an excel file. Once the file is created I would then like to open it for the user to view/edit/save etc. I have the transformers to do all this, the problem I have is delaying the opening of the file, calling the SystemCaller transformer AFTER all the SQLexecutor transformers have been run and the excel file has been created.Thanks