Transformers

I have a dataset, where one of my columns is a 'pack date', unfortunately some of the values within this column are null.I am trying to use Conditional Value within the attribute manager to give a dummy date wherever a null value appears in my table.So far I have:If Pack Date ATTRIBUTE_VALUE_NULL as my test condition.How would I assign an attribute value of, say 01/01/1990? Thanks,Tom 

I am trying to transpose data. I already read some posts about how to transpose a table using FME. But I am not able to get what I want.I have the following table within FME:I want to transpose the data so I get the following format:So I don't need my column names. This is just an indication for myself.Does anybody know which transformer(s) I need to use?

Hello,I have two columns in a Excel sheet "Year" and "Range" with more than 2000 rows. I would like to compare those 2 columns and see if the Year is truly in the Range or not. For example:Year Range 1650 < 1920 1964 1961 - 1970 1970 1961 - 1970 2001 2001 - 2005 1963 1971 - 1980 2015 > 2014 1923 1920 - 1940 1978 1981 - 1990  Thank you in advance for your returnBest Regards

I have a continuous raster with cell values between 0 and 100. I want to reclassify these values to 5 classes:For example everything between 90 and 100 should have the new cell value 1.I do not know how to extract the cell values to make them accessible for the conditional comparison. In the screenshot you can see my current approach. The problem is @CurrentAttribute() which is the wrong choice to extract the cells.What's the correct way to extract the cell value? 

I have FGDB file with 200 attributes. But i want to split the parts and insert them into oracle table.Split 1 : First 70 (1-70)insert into oracle.Split 2: Second 60 (70-130) records insert into oracle.Split 3: remaining all are insert into oracle.Here the oracle tables are different. I need the suitable solution for this.How can i do this by using FME workbench. In real time data there are lacks of records are there we need to insert step by step.

I need to split a regular hexagon into equal parts: 2, 3, 4, 5 or 6. Is there any tool or combination of tools to do this kind of task?

Hi, I have the dgn file.that consists of polygons and text(Like Prj) i want to convert that into .shp format. create the new attribute like name. that name include the shape (polygon also). what transformer used for that. how can i convert that

i have the DGN file. it consists of 85 polygon 85 texts.it was filtered by geometry filter(area,text).the text are assigned to individual polygons. i want to convert it into ESRI shape file. if the attributes have the text string that was matched to polygons. if i click attribute that shows the corresponding polygon. how can i convert? anyone can help?

Hi, I am trying to find the nearest river to points and then merge rivers attribute into points attribute. I am using neighbourhood finder, but in my results I see same values for the rivers attributes merged into the points.

How can I count by an attribute?  For example, start with:AttributeAABBBC Want this:AttributeCountA1 A2B1B2B3C1 Thanks for your help!

I am working on exporting our facility GIS floorplan data to IMDF format. I have been following along with all the tutorials, sample data, and workbenches for Victoria (which is all awesome, thanks)! But I can't figure out how to obtain the scale, rotation, and translation parameters for the georeferencing steps (here). Apple had previously helped us convert old CAD data to IMDF and gave us the GeoJSON they created. Our data is shifted from their data by between 1-2 meters across the facility. It doesn't seem to be a translation alone, but more of an affine transform. I am able to correctly adjust our facility to the data Apple provided in ArcMap using the Spatial Adjust tool, but I can't seem to figure out how to get the scale, translation, and rotation parameters to feed into the IMDF workflow. I don't want to have to maintain a shifted version of my GIS data in our database and using the inline transformer from the IMDF workbench seems a better solution. I&#39

Hi,I have a little calculation problem:I want to @sub(A1,B1) and write the result (72) at A2. Next step A2-B2 (72-18)--> result (54) at A3... and so on. The dataset must be flexible, because the input is not only 3 rows long.Thank you for your help!

I have a grid that I want to label by quartered section. the picture in blue is how they appear in arcmap. picture in black is the requested way. I am trying to use FME to transform the grids labels but I need to open the final product in arc. My real question is, which transformers would help with this outcome?

I'm going through the FME Server Authoring training, and in one exercise it had me start projects that would run pretty much indefinitely, then cancel them........ but there's no cancel button. I know it's supposed to be in the top right corner, that's all the documentation, but it's not there. I can't keep doing anything now because I can only have the one job running at a time in the first place (so I've got another few things in the queue I also can't cancel). When I first start a job, I get the "cancel" button on the confirmation page, and it works... but it's too late for that on these infinity-projects. So... help? Why don't I have a cancel button? And what do I do?? (Note: I am not admin, and the one person who probably is admin is at the Esri conference for the next week ie it's just me with server access currently)(proof attached just for fun) 

Hi, a bizarre thing is happening in a workspace i have (FME(R) 2019.0.0.1 (20190415 - Build 19246 - WIN64)). I am reading in coordinate data (long/lat) from an Excel sheet, and creating vertices using VertexCreator. When I choose to run the entire workspace, the VertexCreator doesn't create the vertices in the assumed coord system and therefore subsequent spatial queries fail. However, if I choose to only run the workspace to the VertexCreator, the points have all been geocoded correctly. I have tried inserting a Reprojector but still it doesn't work.Any help would be most appreciated. It has only started to happen today. 

I have a workflow with some raster resampling and also some raster coercing (back to point data) and I end up having coordinates like this: Also, when I want to write a raster (using Aircom Enterprise writer) I get this warning.Enterprise Plugin: Invalid raster cell size: 99.99999999888921 by 99.99999999339829All my input coordinates and raster cell sizes are Integer numbers, so there must be some internal stuff going on that makes these numbers like this. I found this article: https://www.safe.com/blog/2018/09/fme2018-tolerance-evangelist179/But I couldn't find out how to makes all coordinates integer. Any idea how this could be achieved?

I need to use GeoTIFF Writer with compression method: Deflate.There is no such option on the list. I'm not very familiar with rasters but it seems to be rather popular method.Please help me with this problem.RegardsGrzegorz

I have a point layer with one attribute (categorial string data) that I like to convert to a raster dataset. There are about 20 different attribute values. Each point should become a raster cell. The value of the raster cell should be corresponding to the categorial attribute value of the point. Which transformer with what attribute values is needed for this operation?Thanks for any help!

Hi, wonder if there is a way to get a list of transformers that were upgraded in FME2019? Yarko

I have to export Aircom ENTERPRISE from FME. The data I want to export is categorial point data with information about the land cover at the point's location. I assume this data should go into the CLUTTER writer but I am not sure what input it needs and how to write the menu.txt und index.txt files.

Hi,I've set up an AD connection (basic authentication) this morning and imported a few accounts.I've created a Data Streaming job.I can run the Streaming job from a browser fine (Chrome and MSIE)I cannot connect Power BI to the Streaming url as Power BI whinges with a "We couldn't authenticate with the credentials provided" error.  I have tried connecting Power BI to the Streaming url with an FME Server System account, ie Basic access and it connects fine.I can obviously set up FME System Server account users but we want to use AD connectivity.Has anyone else managed to get FME Server streaming working with Power BI? Thanks

hi,how can I write in AttributeCreator iff the Value is missing than set Value to 0 ?I have the created a form, see screenshot, and that is correct, but sometimes the Value of "_Anzahl_DT" is "missing" and then I do not get any Value in results..I need to write in this form this case, that when Value of _Anzahl_DT is missing, than write 0 instead so the formel can count it with 0. thanks. 

Hello,I am trying to validate the angle of a range of lines to see if they are within plus or minus 10 seconds of a label on the line.I was looking for something similar to the Attribute Rounder but that allows you to specify a value rather than decimal places.The Attribute Range Filter seems close but the values are in a list.If anyone has some suggestions that would be very much appreciated.RegardsDean  

Hi, I want to get the shortest path from a point in dataset A to the nearest 5 points in dataset B. I have figured out how to do this, the only problem is dataset A has 100,000 points (I need to get the nearest 5 points in dataset b for all 100,000 points). Is there a way I can release a single point until it has run through the workspace and then the next point is released? I hope this makes sense, thanks for the help.B

Hi all,I have GPS coordinate as input and I would like to snap them to the closest lines, which works perfect with combination of Neighborfinder. However, While finding the closest, I would like to consider the consecutive points as well.In the images, I have group the GPS point based on timeseries. So if the points have the same color, there are in the same time series. As you can see the closest line for some of the points are different then consecutive points. How can I include the group of consecutive points while finding the closest line to the point?Thanks in advance.