Transformers

Hello Kind People!I would like to create list of the final matches in my POI dataset. Currently I have table that contains pairs of duplicates (table on the left side). However, I would like to create final list, which says if POI where ID=1 is duplicate with POI (ID =2), and POI (ID=3) is also duplicate for POI (ID=2). Then it is obvious that POI (ID = 1) and POI (ID=3) also have to be duplicates.I would like to ask if it is possible to create this kind of list in the FME, if yes which tester can be used to do it.I will be grateful for all hints.

Hello, I had written some scripts on other platforms and ships count is one of them now I want to replicate that using FME but I have just started learning FME and due to lack of time I have to move faster so If you have the suggestion please reply to this question.

Hi All,  When i'm trying to export the Auto CAD landbase objects to Smallworld. Getting the following error. Please help me in this regard. Thanks in advance. Smallworld Translator Error: No URN handler for class unset

Hi, I am trying to georeference some ECW files. I have TAB files which contain ground coordinates of the ECW extents and I've been able to extract these using attribute expose, filter and string extractors. What I now need to do is get these values associated with the min and max extents of the ECW but i'm not sure how to approach this. The Rastergeoreferencer and Raterextents coercer looked promising but neither have the option to apply the coordinates ti the ECWfile. I wondered if featuremerger might help but not entirely sure it would. Any guidance/assistance/advice anyone has about this would be gratefully received. Thanks in advance, Jake

Hello: I am trying to piece my way through building a workspace to process surveymonkey responses. I'm using an HTTPCaller to get the results. However, I have roughly under a thousand responses and I have a max limit of 100 responses per page. I take the JSON results, validate then and use a Flattener to get the attributes I need. But I have to go grab the next 100 results, then next and per the SurveyMonkey documentation, I need to fetch 100 results with the resource url retutned in the links.next field (ex. https://api.surveymonkey.net/v3/surveys/{survey_id}/responses/bulk?page=2&per;_page=100). The issue I have is I need guidance on what's next. I added another HTTPCaller and added the above to it thinking it would get the next results but it's not responding correctly. I know I have to loop and the max will be the number of responses / 100. I could use a good push in the right direction if anyone has done something similar. Thanks in Advance

UnderGroundCable and OverheadTransmissionLine Line are two feature classes. some part of circuit A-B is UGC and and some is OHTL.Both feature classes are related with the Electric Line Table.In the ElectricLine table should be one record with the Circuitname= A-B and other common attributes and length should be UGC=OHTL .Relation is one to many by CircutName field.how i can do this by FME without creation duplicate record.Thanks & Regards, AZA

In ArcGIS there is a tool called "Hot Spot Analysis (Getis-Ord Gi)" under Spatial Statistics Tools > Mapping ClustersI am wondering if it is possible to replicate this in FME ? The example I have concerns "delay minutes" based on incidents on the UK rail system, so it is the "Delay_Minutes" value I wish to be evaluated.

Dear FME users,  I’d like to calculate the median of all overlapping pixel values from 24 input raster bands.  Do you have an idea how to solve it? Can I use the transformer “RasterExpressionEvaluator”?  Thank you very much.  Konrad

Dear FME Users,  I’d like to process 73 input NetCDF-files. The files describe 3 days (73 hours). Every single file stands for one hour. The NetCDF-files don’t include any useful time attribute.  What I need is the timestamp for every single input written in an attribute .The data type should be “date”.  In the following you can take a look to the assignments (input files -> time):  - HRES_ENS_2017062200+019 -> June 22, 2017 “07:00 p.m.” - HRES_ENS_2017062200+025 -> June 23, 2017 “07:00 a.m.” - HRES_ENS_2017062200+071 -> June 24, 2017 “11:00 p.m.”  What I can do in FME is to extract the substrings I need (e.g. “2017-06-22-19”).  I’ve tried following transformers too: “DateFormatter”, “DateTimeCalculator” and “TimeStamper”.  Do you’ve an idea how to solve it?  Thank you very much and best regards!  Konrad

Hello, I have a cad file that contains lines, points, poligons and surfaces and i want to filter the geometry and in the same time to merge all the line on a single feature class, the the poligons , points, etc . I haven't found any transformers that can help me with this. Can you tell me if there is any transformer like "Merge" function in ArcMap? I was using a model builder to merge the features after the translation. Also the same model was used to calculate fields or to add a new one. Is this possible in FME?

Hi,I have a file geodatabase with a number of domains and I cannot work out how to expose the domain values.I have ticked 'Resolve Domains' in the Reader Parameters and then exposed the attribute domain in the following way in the AttributeExposer transformer by typing: '_<attribute>_resolved_' based on the information I read in the following article: https://knowledge.safe.com/articles/22897/working-with-geodatabase-domains.htmlHowever the attribute I exposed is empty in the output file.Can someone please assist?Thank you in advance.I am using FME 2017.0 32 Bit.

Hi,I have a table in MS SQL with polygons and i need to extract the area in sq km and sq h for each (depending on location) so have built a work space that re-projects into 3857 does the calcs and re-projects back in 4326 apart from the answers are not the same as QGIS gives me:Im using plane area with multiplier of 1

I have two point datasets (image below). There is a 1-to-many relationship between the yellow squares (1) and the red circles (many). The points are related by an ID attribute which is common to both datasets. I need to draw connecting lines from the yellow squares (the "hubs") to the red circles ("spokes") which share the same ID. I've read a number of previous posts regarding connecting points in separate datasets but they all seem to deal with either a single point connecting to many points or many-to-many relationships between datasets, but not a one-to-many relationship between two large (5,000+ rows) datasets. Any advice or info is much appreciated.  Cheers,Rich

Hi,I have many points created with vertexcreator. These points are connected each other ( two by two ) and formed IFME Line. There is an order for each point. After 6 points there is a break. Then 4 more points connected each other 2 by 2 ( forming IFME Line) and the last one equal to the first point at the first Line.I have to obtain two lines at the end , using LineJoiner with the 6 first points and then with the 4 last points. With these 2 lines i will to output the succeeding description of points coordinates using geom: Get-point ().The problem : like the last point is equal to the first point, the LineJoiner connects the two lines . It's not what i want.How can i do ? Is there an other solution if i want to obtain the list of my points coordinates ?At the end, i have to obtain the list of each coordinates point (x,y) for the 2 "big" lines but the point connection ( first and ending points are similar) must be in the two lines.Can you help me ?

I have an interesting challenge. I've been provided an AutoCAD DWG with blocks placed using an unknown (an so far unable to be determined) projection and asked if I can take some source data in MapInfo (GDA94) and place it onto the DWG. Obviously without knowing the projection its not a trivial problem to make assets line up.What I am able to do is in the source data identify objects that exist as blocks in AutoCAD and match on feature attributes. This gives me around 3,000 common points with locations in the unknown coordinate system relative to the known source data. I thought I might be able to use the rubber sheeting transformer to create a transformation that would simulate a reprojection but the closest I've managed seems to result in the geometry being stretched in the y-axis by around a factor of 2 to 5.Am I just looking down a fruitless path or is there some hope? Can anyone suggest an alternative approach given the ability to match two sets of points within the two sy

Hi,I am reading in a DGN TIN and then using a GeometryCoercer transformer to convert the data to fme_polygon. I am then outputting the polygons to a Shapefile writer.However the incoming dataset is so large that it is failing to write out completely to shapefile due to shapefile's size limit of 2GB.Is there any transformer I can use that will somehow compress the data so that I can write it to shapefile (I need shapefile and can't use any other output format)?I am using FME 2017.1 64 BitThank you in advance.

I am searching for a transformer where ITopologicalOperator.ConstructUnion in ArcGIS..

I have a built and design areas which have lines inside them, and would like to style the lines based on the status of the area it exists in.i.e: Area - Built = Blue lineArea - Design = Red line

When I run an FME Script in one repository containing a custom transformer, FME Server will sometimes incorrectly use a custom transformer with same name from a different repository.  I have separate repositories on FME Server for a set of workspaces. I would like to extract some logic into custom transformers that would be loaded into these repositories. Unfortunately, it seems that FME Server sometimes loads a transformer from a different repository. I can run the same workspace in one repository twice in a row and get a different result because it will grab a transformer from different folders on different runs.

Hello everyone,I´m still thinking about issue when after successful translation all folders in some path will be zipped. I have no idea, how to do this via simple workspace. Maybe only one possibility is to do that via Shutdown Python script. Unfortunately I´m not a huge expert in Python, could anybody help me please?Thank You so much!Lubo

Hello...I would like to sort the output of the Attributepivoter. Is this possible? For example, one of the group by rows is month and I want to sort this output based on the calendar year months (Jan. to December). Thanks.

Hello,I try to solve two problems. Database in my project contains many types of geometry - points, lines, polygons. I need to do bulk conversion of every coordinate by 2 decimal places. E.g. One point feature has X coordinate 152,125 and Y coordinate 696,745. I need to convert these values to X coordinate 15212,5 and Y coordinate 69674,5. Does anybody idea how to solve this problem please? Second problem is about work with lists. I have met many times situations when I use list in XML templater. I had to divide values of any attributes in list, so I have to specify index of feature in list, e.g. {fme:get-list-attribute("_indices{0}.x")}. But how can I specify, that I want to put there all values without index 0 please?Thank You so much!Lubo

Hi,is it possible to radiate a line connection between two points, so that it is a vertical and horizontal part?...indicated by the red line.

I hope someone can help me out. I have some curb lines that are poorly drafted. I tried to use Snapper (with various snapping tolerance ranging from 0.1 to 5) and then LineJoiner to join them together, but had no luck so far. I attached the file here so if you want to give it a try, please go ahead.Thanks in advance.

I've pairs of two nodes which have an offset in between. I need to add in the middle of each pair a new feature (see the left diagram). The first table shows the current list with the node pairs connected by the attribute ID. I like to create a new list with the new created node-features. Is there a way to solve this problem with existing transformers?