Transformers

I have two tables having ID column in common. These IDs are repeated multiple times in both the tables. Now I need to merge these two tables into a single table based on this ID field. I tried using Feature Merger, but the results were not as expected. Some data were missing. Is there any effective way to do a many to many join in FME?  

i have issue with date some times i have attribute has date 01.02.2010 in this format and some times the same attribute but in another excel file it shows 20100304so when i use date converter and i set format as input %d.%m.%Y$ output %Y%m%d i need output format in this format %Y%m%d because of the rest of transformer condition depends on thsi format .but from the beginning i want to check the date ,if this attribute whatever comes,it should convert to this format %Y%m%di tried with tester before it ,i am not sure how to set it ,as i want to check if the date include this format %Y%m%d so pass if not ,so u have to convert whatever the format to this format as 20100304 but one of another excel files that caused me terminated ,FME reads it as 01.02.2010and i thought ,i can get output of dateconverter when it rejects to use as input so i connected output and rejected to next transformer ,i found the

Hi All,i have a polyline for which i would like to find the digitization direction. and based on this i will be applying the driving direction for this line .I am not sure how i can find the digitization direction for polyline , can somebody help me with this .?I checked with azimuth calculation but not sure how i can use this any guidance on this will be helpful. Thank you in advance .

Hi all, I saw that a WMTS reader has been requested. But meanwhile, I would like to ask whether anyone of you implemented a workaround to read WMTS.I want to read the orthophoto via https://www.basemap.at/wmts/1.0.0/WMTSCapabilities.xml and crop it by a polygon. However, I cannot currently read it. Thanks in advance and stay safe!Best, N

Hi all,I am trying to run a workspace on FME Server (2019) through the Data Download service. This generally works fine in terms of authorization etc. I can successfully pass parameters (and directives) to it as a query string. However, one of the parameters is geometry, currently encoded as OGC Well-Known Text. The input for this parameter can become quite large, as the geometry will be passed to FME Server from a web map. When this happens, the URL exceeds tens of thousands of characters and this seems to break the request.Because of this, I am trying to pass the request as POST, keeping all parameters in the body and thus the URL nice and short. However I can't get this to work - the parameters in the body are ignored and the workspace is run with the default parameters every time.The FME Server Data Download logfile has this line every time:POST request received. Redirecting to GET method. Is it possible at all to use POST to start the Data Download service? If so, how do I pass pa

Hi list.This may be obvious to some, but I'm not very proficient in raster handling.I'm building a custom process that manipulates one DEM, and checks with another DEM.Both input DEMs are GeoTIFF with a single REAL32 band that contains the height information. My output should be of a similar construction.I'm using RasterCellCoercer at the input to vectorize, and ImageRasterizer to create the output image to be stored as GeoTIFF.However, ImageRasterizer does not offer REAL32 as an option, only multiband RGB(A) and single band 8/16 bit options.Is it possible to create a single band REAL32 GeoTIFF using FME, and if so, how ?Using 2020.0CheersLars I.

I'd like to use the TopologyBuilder but had some troubles to get it work with 3D lines.We want to consider the elevation when computing the topology so that:nodes are only produced were lines intersect in 3Doutput nodes are also 3DAttached workspace is my first attempt (that works) but I'm curious if theres a better solution out there.Peter

i used Network topology builder calculator , and each line has specific id so i get the output for which id is connect to which id ,but i have one problem when more than one line intersected it repeats id more than one time bcs as example id 5 connects with id 7 and id 9 and id 10so it repeats one id ,many times it depends how many lines connected to the same point ,so i would like to ask ,how could i give for all connects point the same id_network bcs if A connects to Band B connects to Cso A CONNECTS TO C so all of them should have the same id _network id_network for A =8id_network for B= 8 id_network for C = 8I WANT TO give the same id_network for all lines connects to the same point i do not want to repeat one id more than one time .  

Hi. I am working with FME 2019.1 and I have created a workbench that needs to be run by a person new to FME.The wb uses PostGIS database where the connection details are 'Embed Connection Parameters'. There are multiple hosts which come as dropdown options (choice parameter). So, when I have select a database from the dropdown, next thing is the schema that should be reading/loading by itself of the selected host. But, that's not coming.What is now- Problem faced: It is done manually by copying the schema name from PostgreSQL server to FME. Any ideal solution for this?Thanks.

Hello All,I apologize if I am not making much sense, as I am new to 3d modeling.I am having trouble trying to think of solution. I want to take spatial-vector data and output to local coordinate system. The local coordinate system, ideally, would be constraint to min and max extents of: -1m, -1m, 0.5m & 1m, 1m, 0.5m.Right now, I am getting values larger than min and max extent when using localcoordinatesystemsetter X CommonLocalReprojector. I am not sure what I can do to equalize each x-, y-values in order to scale appropriately. Nor find transformer that I can input area-extent as min/max extent constraint. I am sure there is a mathematical formula, but am lost. For example, point-1_Local = -7.5403653628193155, -5.638463266998554, 0.5point-1_LocalConstraint ~= -0.4817, -0.504, 0.5 point-2_Local = 7.502099056082192, 5.551721092860062, 0.5point-2_LocalConstraint ~= 0.8439, 0.828, 0.5 

Hello,I'm trying to find only the letter D on its own in a string such as the following: B,G,D,DM,TD,DM,TD,D. In this example, that would be 2 D's (the third D and the last D I've marked in red).Unfortunately, all the regex expressions I've tried also gets the D within TD (e.g using D,|D$). Thanks.Tony

I used the surfacedraper to drape the cogopoints on a surface, i'ts look like he doesn't do anything.My goal is to compare the height of the cogopoint with the height of the surface on the same x-y coordinate.My thought was to drape the cogopoint on the surface and compare the height. civil3d2none.fmwbasic.dwg

Whats the best way to extend a raster to fit a larger extent, filling the additional space with the nodata value of the raster? Many Thanks for the help

Hello Team,I am loading data from .JXL to SDE, While loading data i got following error, Could somebody help me out with some resolution for the issue.|ERROR |An error occurred while attempting to add a shape to a feature buffer. The error number from ArcObjects is: '-2147220936'. The error message from ArcObjects is: {The coordinates or measures are out of bounds.} Thanks...

Hi I have been provided with a dwf file with pipeline information. I would like to extract the pipeline and attribute data. I was thinking I can use nearest neighbour method for this but I can't even extract the text or specific pipeline data. Could someone guide me with what I need to do to expose the attribute to get this information.

Hoping someone can help with this. Since upgrading to 2019.2 our existing workbenches have begun to fail. Each time a coordinate system is called on it appears to be missing a curly brace at the end. E.g. "{EPSG:27700 is not a valid key name." or "{OSGB-GPS-2015 is not a valid key name.... Last line repeated 11 times ..."These are only warnings until eventually the workbench fails under:"No definition was found for coordinate system `{EPSG:27700' "Wondering if this is a bug or if we are missing something? Let me know if I need to provide more info.

Hello,  I try to connect points to assess certain river characteristics. I used LineBuilder > connection break attributes (to the attricube that speficies one specific profile along river). However, it's not one, line but split up in several parts, even though the attributes do have exactly the same number.  What is the reason for these 'cuts'? And moreover, how can I connect the lines?  Thank you very much!   

I'm trying to generate a cell averaged DEM to generate smoothed contours within FME. After converting bare earth las points to a DEM using the Raster DEM Generator (1' cell), I want to average the values of those cells for smoother contours and it seems that the Raster Convolver is my best bet. Within the Raster Convolver I'm using a 5x5, weights all set to 1, Divisor set to 1 and Operation set to Mean but my results arent really matching what I can create in ArcGIS, they appear to be shifted to the side, about 2.5'. The Focal Statistics tool in Arc can be used to average the cell values of my initial DEM in a 3 cell radius with proper results. Are there different settings I should be using in the Raster Convolver or is there a better way to go about this?

I have approx 600 points based on top of a surface. I want to be able to generate a 5 meter long line in each of these which is in the normal direction of that surface.This is to be used for planning boreholes in a tunnel.Finding the normal of a surface is ok - but the normal of the point on a surface seems to be more difficult. The lines that needs to be generated is created manually on the last image. 

Hi I have a GeoTif file and need to convert it to RAW format for import into Unity as a terrain. Anyone know how to do that? Tried different options but nothing seems to work.

Hi. A calculation has been completed in FME and a PDF of the results has been generated. The results are shown in tabular form. We also want to generate a graph/chart from some of the data and add this graph/chart to the PDF that is produced. Can anyone provide any guidance on how this can be done?

I have two MicroStation Files, one is a parcel map with parcel numbers inside each parcel polygon. The second file is a right of way polygon that intersect the parcels. How do I create individual parcel polygons of just the right of way intersections and attribute each polygon with the parcel number?

"2046": {        "ID": "020935",        "Address": "Bagg Close 9, 29643 Churchtown",        "Provider": [            "D2 - GSM09",            "D2 - LTE08"        ],        "Locationdocuments": {            "stob": {                "date": "/Date(1412546400000)/",                "Applicant": "Vodafone",                "STOB": "c8859eec-63b2-4a75-a2c2-00a586110005",                "TD": "74c192b2-0067-40fc-a41d-f5b5f73afbf1",                "BZ": "0eb422f8-0561-4f4f-8324-d7110ff56ff0",                "LP": "0b37ed04-4d01-4f07-b67f-d8bd2590a66c",                "AD": "c019cc03-c812-4816-8024-407cedeb461c",                "IBA": "9684e283-10e6-4e95-8931-3906fd3a62cb"            },            "12.09.2014": {                "date": "/Date(1412546400000)/",                "Applicant": "Vodafone",                "STOB": "c8859eec-63b2-4a75-a2c2-00a586110005",                "TD": "74c192b2-0067-40fc-a41d-f5b5f73afbf1",                "BZ": "0eb422f8-0561-4f4f-8324-d7110ff56ff0",               

 input  required output   i have duplicate ,same many id in first columnfor each duplicate has different values in attribuute worldas input excelfor id 400 has 1,2,7so i want to extract one id from the duplicated one id called 400 for the three duplicated id and in front of this id 1,2,7 change all values in attribute world that contains 1,2,7 to new value for any id not included in world attributethen chack again if we have another duplicate value in id attribute ,same method ,extract one id as 267 and it contains 3,11 in attribute world so change any value in attribute world to new value for any idso i want to check at first column if i have duplicate of id in first column so i want to extract only one id from duplicate and it contains 3,11 so change any value in world attribute than contains 3,11 for any value to new value not in cluded in world attribute i mentioned in color background ,what i need to do exactly .iam not sure how to do that,i hope someone suggests me good idea.Than

I would like to ask ,if I have four excel file I want at first to compare between two attributes ,Id attribute ,both of them should have the same attribute but some times one excel file has more than another.So ,I would like to check which has more and If first excel file has more than the second excel file so I want to know the new id and extract for each new Id from the third file the data in this row belongs to this id. And at the same time If the second file has more id than first time ,so I would like to extract know which Id is more in second file and add them to first file and extract the data from the fourth excel file .So I want both of excel file ,first and second should be matched in Id and each one extract the missing data from separated file .Because only common between first and second is Id and the rest of data from another two files