Transformers

I'm working with the ChartGenerator Transformer to create a bar chart and have two questions:1) How can I change the bar colour so each bar is a different color? I did find a post to change the RGB to (0-1,0-1,0-1), but my entry is still pink, so I can't use that.2) How can I add a label showing the number of items at the top of each bar? The PowerPiontStyler has an option for "Label Data", but I don't see one within the ChartGenerator. Currently, my table is shown like this:Thanks in advance!

In the training examples for converting from ifc to citygml, the site information is not taken into account.How can I keep the site information after converting it to citygml?in another meaningIn the attached file there is a structure in .ifc format and I want to create a writer on FME DESKTOP in CITYGML format. How can I transfer the location information to the CITYGML writer without lossing any of it?

Hello! I have two data set that I want to join spatially and not by attributes because there are no common fields. I want to merge (for example a layer of cities and a layer of population (I want to merge to know how many people they are per city). I tried spatialrelator and featureMerger but I failed Thank you for helping 

Hi altruist, I have a set of data MITAB data in LL-GDA94. Which transformer should I use if I want to transform it into GDA94?

I have created a colored mesh from a LAS file using PointCloudSurfaceBuilder and would like to write it to an OSGB file. My overall intention is to convert the OSGB to SLPK using ArcGIS Pro, as the FME I3S SLPK writer does not produce good results.  After writing the OSGB file using FME, the colors are gone, as the front appearance is set to one single ambient and diffuse color. Is it possible to multiple colors per mesh part?  Thanks in advance for Your help!  

What does ifc coordinate 0 mean as shown in the pictures What is the coordinate system for the reader that we have to add? Do we add ll84 or x-y M?

I'm attempting to extract a link from html that looks something like this: <a class="email-link" href="https://app.myapp.com/results/a7696ced77454dd39d8241e79f981b3d">here</a>. using the xquery extractor. the x-query //a/@href seems to work in the online testers but not in FME. Any ideas?

I have dynamically transformed CRS system of the tables (MGA94-56) from MSSQL database and then written into another MSSQL database (MGA2020-56) with same table schema. I can see the new tables exist in the SQL server. Also When I am checking the tables on FME workspace by using CoordinateSystemExtractor, I can see the tables are transformed. But the data is not displayed on QGIS, though attribute table can be seen. Also in QGIS property option, the CRS system is still showing the old one. Can anyone kindly tell me what could be the likely reason/s?

Looking for alternative ideas/methods to texture a set of 3D terrain TINs which are tiled with images from some kind of image service (WMTS, WMS etc). The images and TIN tiles don't share the same extents My current process involves the following steps: Fetching and georeferencing the images, Merging the images in to one mosaicClipping/Tiling the mosaic to match the TIN tiles (here I also pick up the tiles ID)Use the AppearenceSetter (Grouping by the TileID to set the texture on each TIN tile). Here i use the TopDownGeoreference methodWrite the tiles out to format X (e.g, OBJ) Performance is slow(est) at the Mosaicking, Clipping and the Writing out parts (2, 3 and 5). Now, I see that FME 2022.1 has the option to now Clip surfaces which are textured. I'm thinking about changing the order a bit here to try and take advantage of it but before I did I was curious to see if anyone had any experience with this kind of workflow. @daveatsafe​ perhaps you might have some tips?

I am currently switching a project from Arc to FME and I am replicating different Arc operators to FME ones. I currently have a problem regarding RasterResampler as outputs from Arc and FME differs though using the same specifications (cell 0.05 and bilinear transformation).I am including a zip folder containing input maps, output after transformation from Arc and FME and the FME tool. I also tried a workaround, but it creates more transformers, doesn't get better results in general, and defies the point regarding processing time. Thanks Sébastien

Hi, Basically, I have two point clouds that overlap. One with colour, and one without. I want to find the nearest point with colour to every point without it so that I can use the colour from the nearest point I can do it by:Coercing the subset of points without colour into individual pointsMapping the XYZ of the coerced points to an attributeMaking a small buffer around these points (say 2.5cm/1 Inch)Then clipping the remaining cloud to a small area around each buffer (creating a large number of small point clouds that have the XYZ of each original point without colour)Turning the coerced XYZ attribute values into a component of the small coloured point cloudsFinding the smallest distance of each point cloud between the coerced XYZ component and the coloured XYZ component Using that smallest distance to find one point in each cloudReplacing the XYZ of the nearest neighbour with the coerced component and thereby finding the closest RGB value for the original points that had no colour.T

Hello, I have in my attribute, words separated by comma. I would like to have a word by attribute not all the words in an only attribute. I used "AttributeSplitter" , a list has been created, then I used "Listexploder" and I have my words (which were in an only attribute) separated but not in several attributes for the same feature, it created several features! I want separate word (which were separated by comma in a attribute), in different attributes (one word by attribute) with the same number of featuresThanks ! 

I would like to have overlaps of the features by creating attribute with all the names of the other features which overlaps. I used AreaOverAreaLayer but It's not what I'm looking for. With this transformer, I only had the number of overlap.Moreover, with this transformer, if a feature (polygon) is overlaped at two different location of this polygon, it creates me 2 features different, but I want an only feature for a polygon. A feature by polygon. Thank you !

I have two datasets from OSM for a small region: roads and waterways. I want to count the "bridges" resp. all kinds of crossings between roads and waterways in FME. I can't find the right Transformer to do this (or I just don't see the right options if I already found a suitable transformer). I tried e.g. "Intersector", "LineOnLineOverlayer", "SpatialFilter". Maybe I'm just missing a small detail. What Transformer and options should I use? I got helpful hints here at gis.stackexchange.com, saying that I could use an Intsersector, a ListHistogrammer and a Tester. Unfortunately, this does not work for me:  In the two respective Readers with OSM data I exposed the fme_basename attribute and use it for list generation. However, the Tester does not detect the correct nodes when I check if the histogram{0}.count equals 2. What am I doing wrong? Or is there even another, much simpler way to count the crossings between two feature layers? Tha

How to convert from IFC to CITYGML with correct georeference to UTM84-37S ?

I have connected to an API to download data to create an automatic process. The data covers the whole UK so comes group by region in folders, but I can not figure out how to expand these folder to have the remaining SHP files inside for clipping and symbolising etc. Im sure there is a tool for this I am probbaly unaware off. (See image)

Hi Altruist, I would like to bulk reproject on a number of database table in SQL spatial server and write (update) the tables into same database after the reprojection. All tables are in same CRS currently but obviously schema are different. Can anyone kindly suggest a tutorial/workspace of same sort?  best regards and thanks in advance.

Hello,I am trying to set up a simple flow to automatically copy new or changed data from multiple excel sheets into the master Excel sheet that lot of PowerBi dashboards feed from. The flow is simple as follows:-Read from sheets -> Attribute Manager (rename to match main excel) -> Change Detector -> Attribute Creator (fme_db_operation (UPDATE)) -> NullAttributeMapper -> Writer. Problem is at the last stage, the writer is not updating the main sheet and could not find the correct setting messing around with the writer parameters. Any help would be appreciated, I have attached the screenshots below.

I have a dataset which contain null/non-null values in a particular column, I have to segregate it in the way that if any null value exists, all null/non-null values will go in 1 direction else only the non-null values will go in 2 direction (port), help?

I'm having trouble pivoting a table. Here is what I am trying to accomplish: Is the AttributePivoter the correct transformer to use? Thanks in advance, M

Good day, I would like to ask. I am currently solving the tracks in the WS in the attachment. I ran into a data "loss" issue happening on featureMerger. Points from the polygon of interest go to the Requestor's input, and points with the same ID as the requestor's input go to the Supplier's input - these points are part of the RouteSegment. Now to my problem. I believe that I don't have all the data on the FeatureMerger output because I only have each point once on the requestor input, however, I can have a point multiple times on the suplier input and it can be part of different routeSegments. At the moment when a point at the requestor input is "reserved" by the first point of the same ID on the supplier, at that moment the rest of the data goes to the Rejected output. I can think of creating X featuremergers, where I would send the rejected data to the input of the supplier and the original polygon_selection_topsky source to the requestor. But I f

I'm new to FME and impressed by what can be done with it. However, I got stuck regarding some details. I have a PointOnAreaOverlayer transformer and I wonder why the Point output port let's me use all attributes, whereas the Area output port generates no output for some attributes that I need to use. What is the solution here? Thank you!

I am constructing a workspace that builds a file geodatabase from a schema specified in Excel. Each worksheet row defines an attribute and its feature class and feature dataset hierarchy (and domain, if any, but that will be for another day). The schema has feature classes mostly nested in feature datasets but some are root level. For testing, I have extracted a small sample of the schema, representing thirteen combinations of feature dataset and feature class with one feature class at root level. Now, after Excel file reading and subsequent processing, near the end of the workflow the attribute records go through an Aggregator transformer, which creates the attribute{} list attribute. The result is thirteen schema features. Schema features exiting from the Aggregator have no geometry, of course, and consequently have fme_type=fme_no_geom and fme_geometry=fme_undefined. I created and set the following attributes on each schema feature to hold the values that I want to specify as

I have thousands of data, and each datapoint has six attributes, which I want to store in one list per data point. Which transformer could be used for this?