Transformers

Hello, I have a table with some attributes and I created a new column which is called "Description" with the following string, by using the text editor in attribute manager : "New values, Dat: @Value(Dat), Nat: @Value(Nat), OBJNAM: @Value(OBJNAM)" However in some cases there are no values in all those attributes and the output looks like this:  "New values, Dat: , Nat: Underground heigh., OBJNAM: , " I would like to exclude the attributes that don't have a value (in my example the Dat and ONJNAM), for each row.I guess I should use somewhere a conditional formatting but I am not sure how and where to do that.  

We prepare kml files from Tab files as a regular practice to show our maps on our websites. However for multigeometries the popups don't work on our websites. These popups work in Google earth for the kmls but always fail in the web API. Any idea?

Dear FME community, we are working on developing a 3D Web application to visualize 3D Buildings (CityGML LoD2) and other 3D assets in CesiumIon/ CesiumJS. We have been able to create LoD1 and LoD2 3D Tiles that we can use in the application but the 3D Tiles output is very data intensive and really slows down the rendering in our application tremendously. That leads us to think that there might be something other optimizations we can undertake to improve our workspaces for better 3D Tiles creation that can be streamed better in Cesium (e.g. cascading structure of 3D Tiles or splitting of large tiles into smaller chunks for optimized web rendering). Furthermore, we are having problems with successfully creating 3D Tiles in LoD2. We would like to create building solids that are selectable and have all the desired attributes attached to it instead of having the surfaces being individually selectable.  I have attached 3 workspaces that we are cur

I am trying to use the HorizontalAngleCalculator to calculate the angle of some lines but it seems that even lines that are quite obviously 45 degrees are getting strangley small angle values. I have checked it it is set to be in Degrees, I'm wondering if anybody can point out what is wrong.  

ho un dato poligonale di tipo multipolygon. Ad uno stesso identificativo, corrispondono più poligoni. Per ciascun poligono, nel campo Area, è presente il valore della superficie. Devo calcolare la somma delle aree dei poligoni con uguale identificativo

I am working with Copernicus WorldCover data and I wonder how FME is reading pixel values. I read the data with a FeatureReader, to intersec t the input with my AOI, and looking at the cached results of the FeatureReader I get 'NoData' in the Data Inspector, when selecting an area where the color map is interpreted correctly and according to the product description from ESA the color indicates a map code of 90.The subsequent applied RasterMosaicker shows the following result, at the same location.Now the value changed from '0 NoData' to '10'.As described, the color indicates a value of 90! The problem is basically present in any of the mapped classes, and values a

I used the ArcGIS Online Feature reader to read a hosted arcgis feature layer that has attachments. I can use the AttributeFileWriter to write the attachments to files. But when connecting the reader to a file geodatabase, the feature layer writes to a feature class, but the attachments are not included. Is this the expected behavior? I am at FME 2020.1.3.

Hi all. First post for me here. I have a workbench where I want to overlay a point dataset on a single band geotiff elevation raster dataset. This workbench will be published to FME server where ppl will uploaded their point dataset and terrain Info will be calculated. The GeoTiff dataset is large >10 gb. To speed up the process I have tiled the dataset into smaller tiles and created a shape file index. I only want to load the tiles which overlap the point dataset. I find out which tiles overlap the point dataset and then, using a feature reader transformer, I’m selecting the tile to load. My question is, what would be the best way to load multiple tiles if the point dataset overlaps more than one tile. Is it best to use multiple feature readers with each tile being passed to one feature reader. But I’ll never know how many feature readers I need. Any thoughts. TIATK

I have a feature service link from which I extract data, but I cannot see the latitude and longitude in the tables. When I inspect the data, I can see the details. Can anyone tell me how I can extract the location details?

I hope this message finds you well. I am reaching out to the FME community to ask for suggestions on how to map transmission lines data using sub1 and sub2 columns. Our goal is to find the node mapping between transmission lines and substations, and we have the necessary data in these two columns.I have been working with FME for a while now, but I am not sure about the best way to approach this mapping task. Any advice, tips, or best practices you could share would be greatly appreciated.Attached the piece of data for understanding.Thank you in advance for your time and expertise. I look forward to hearing from you soon! 

Hi, I am using the census bureau's API to gather population data for a county, and the data returns in the response as two separate arrays. One array contains the headers, and the other contains the data:  [["NAME","B01001_001E","state","county"],["Spokane County, Washington","546040","53","063"]] I am mainly having issues with transforming the data in this format as it isn't what outputs normally look like when using other REST APIs. Using a JSONfragmenter will correctly assign these as two distinct arrays, but I can't seem to figure out how to associate the corresponding values to build a table from these arrays.

What transformer can I use to snap the red line to the black line keeping the intersection point (blue circles) in place? Anchored Snapper would snap the edges but shortens the red line while Affine Warper works only for short lines. Thanks!

I have loaded some features from an Open Street Map file (.OSM). Some features have the attribute "oneway" and "oneway:bicycle". I'm a able to create a test clause targeting "oneway". When I try to do the same for "oneway:bicycle", I get an error: "Specified attribute does not exist" (see image at the end). This causes the software to show a warning before running the workflow. Strangely enough, the filter is applied perfectly fine! Am I doing something wrong? Or can the warning maybe be a bug? 

I have a workflow where I use the schema port of a FeatureReader (format Geopackage) to check if the schema of the input gpkg is correct. This works fine for a single file, fme_feature_type_name provides the table name, and I have the list of attributes.However, if the input is more than one file, the schema is a 'global' schema combining the schemas for all input files, avoiding double tables. As a result I cannot check each file separately.I found out that using the FeatureReader with type Schema (any Format) gives on the generic port all tables as feature, with the attributes list, for all files. But here is the problem: when using Schema (any Format) on a geopackage, these tables as feature on the generic port do not expose the table name. I expected fme_feature_type_name, but this is not available in the output. fme_feature_type gives 'schema' as value.Is there any way I can get these table names ? Thanks,Marc 

Hello Sir/Madam, So I have many models in CityGML formats. I would like to put it on the Cesium to view the data. However, as some of the models (CityGML) are huge, I guess it have more than 300 features for each models. Hence, the FME cannot convert the CityGML to Cesium 3D tiles format.  I am sure my citygml model is fine, as one of the model is able to convert to Cesium 3D tile and able to view it on the Cesium. Is there any way I can convert all the models successfully? Thank you.

Hi FME community,I am still fairly new to FME. I'm getting stuck with date/time fields in csvs and excel documents. I've attached the field I'm trying to convert into DD/MM/YYYY HH:MM (%d/%m/%Y %h:%m ?), but it writes out empty if I try the DateConverter or AttributeManager> Text editor > DateTimeFormat. It's likely I'm using the transformers incorrectly. Is anyone able to point me in the right direction?

Hello ,I have multiple lines connecting to each other in shape file and each multiple lines has different id with increment 1 ,as example : multiple lines include id ‘s : 250 ,251 ,252,253 ,….and different multiple lines include id ‘s : 4090,4091,4092,4093,….I would like to combine the lines together that connecting to eachother and increment with one from others id  my target : to convert each multiple lines that looks like square to polygon and also the street lines to be together as seperate another polygon . i am not sure how to achieve that,so i have thought that may be i combine id with increment 1 , i hope if someone has idea ,let me know please  FME 2021Thanks for help  

In the attribute manager, I would like to create a new field called ('Age') and calculate the attribute value from another field called 'Date of Birth'. This is within an automated process that will be run multiple times a month, so I need it to take the time that the process is run and use that for the age calculation. How can I do this? This is my attempt at this : (GETDATE() - @Value(Date of Birth)) / 365 (although there is no GETDATE function as far as i'm aware of.)  Thanks in advance!

Hi,I have a rail network, featuring multiple polylines. I need to snip 50m from the ends of each line.Using the Snipper transformer, I use the Distance (Value) mode. The Starting location is 50, the Ending Location is the length of the line -100 (accounting for the 50 already removed at the Starting Location... maybe?!).The results are mixed: A dead straight line has 50m removed from each end, this is what I want.Any other shape of line only removes the starting 50m, but NOT the end, as shown by the red "X" below. The blue lines indicate the Remnants.What am I doing wrong? Can anyone help please?

I have an existing dataset with labels where I want to increase the font sizes of all features. This of course results in overlaps in places, and I am trying to figure out if parts of the repositioning could be automated with FME. What I have is the original placement and sizes of the labels. I would like to use these placements as starting points, increase the font sizes and then move anything that starts to "entangle".I have read up on the MapTextLabeler, as best I could. It should do what I need. But it comes at a price, I don't know how steep, and I only need parts of what it offers.Has anyone had any success building a workspace that spaces stuff out? My thoughts are:1. Create bounding boxes from the label, sized in ground units.2. Check if any of these are "to" close3. Move those in need further apart.4. Check to see that no new overlaps have occurred.  No 3 above

Hi All, I have kml and image as input files. The requirement is to generate another image by merging both. I have merged both and able get the raster, but I'm not getting transparency in the area within the polygon.I have attached pdf file of requirements and workbench for better understanding... Thank youPratap

I have a raster that gets cut up to smaller sections in a clipper. Within these sections the cell values need to be identical. I have used a RasterStatisticsCalculator to get a mean value for each section. But how do I write these to the cells? My guess is that there is a step missing in my workspace below where the attribute need to be "written down" to cell level? Unfortunately I can't find a transformer that does this. I might ad that I have tried a different aproach where I wrote the mean values as a new band, and then removed the old one. This got half the job done, unfortunately, it also overwrites null values. Which means I end up with bounding boxes around everything, and corresponding stray values.  

I was wondering if it is possible to convert KMZ-files to CityGML? The KMZ-files contain a doc.kml file and a folder (models) which contains model.dae, model_textures.txt and a texture folder containing a .png. I´ve been searching for a valid solution but I can´t seem to find one. I have looked at the common data workflows (https://www.safe.com/convert/). Does anyone have any ideas how to solve this problem. To note: each KMZ file is representing a building, which we want to convert to CityGML so we can use 3DCityDB.  Thanks

Hello everyone,I have been scouring these forums for a solution and found a few posts with similar problems but no solution seemed to work for me. Granted that might also be due to my limited experience with FME so here I am. I am trying to rework a table from this:to this: I have been trying out transformers such as AttributePivoter, Aggregator, AttributeExploder and a few more and also tried to create colums using AttributeCreator and AttributeManager (but I couldnt get it to automatically create colums based on the unique Methodology-Codes, there is too many in the original dataset to do this by hand) I would be thankful if anyone could push me into the right direction, as I cant seem to ma