Transformers

Dear Sir / Madam, Actually I am trying to match two excel table values (attributes name from two different samples). In the excel, I have one matching table and two models attributes in two tab sheet. I would like to compare the value with Model 1 and Model 2 based on the matching table. For example, apple matching apple. However, some of the naming are not exactly matched with wording and are slightly different, such as Pineapple in sample 1 is equal to USA_Pineapple in sample 2. Is it possible to do that? Also, if possible, could it be not case sensitive? Then, I would like to perform a value check on two samples based on the matching table I provided. The result that I want to get is on the "Output Sample" tab in orange colour. I have attached my sample data here. I hope you understand what I said and I hope it is possible to do that. Thank you all and have a good day!

Hey there,I'm struggling with the RasterCellValueCalculator. As I have raster files which are not congruent to each other and not of the same resolution (but overlapping), the transformer doesn't calculate properly. It's just a simple substraction.I already tried to bring the rasters to the same resolution.Can anybody help?I added a sample workspace. Cheers,Maria

Seems like exposing elements in AttributeSplitter doesn't work in FME 2020.0.1 (build 20218). Even exposing attributes after splitter with AttributeExposer is broken.Or maybe it's Data Inspector's fault for not displaying them. Any thoughts on this?

As a rookie of FME, i have an attribute call JEAN i want to create in the attribute , two choices of values in a string to use it in QGis Attribute : JEAN string : Yes or No How can i do please ? Thanks

Hi I need to sort in ascending order and only keep the first 4 rows of the result. So I used a sorter but I can not find how to limit the number of rows in output. Thank you

In the Manage Automations page I can select and automation and then select Actions, but the Trigger Automation item is greyed out. Do I have to trigger each schedule in the automation manually?

Hi!I have a problem with a Json Templater and an Aggregator. I would like to have this result :In my data, I have two items (Json_fragmenter_19) and I need to aggregate them to match with the result I want.I do this :I tried different code in the JsonTemplater but it doesn't work.Can you help me?Thanks Laura

Dear FMEI want to connect a series of points that follow a certain road alignment.I have a set of point data that are snapped to a road alignment. The point data were registered by different equipment several times in a year. Unfortunately, the point data do not distinguish between different equipment. However, there are two registered dates for each point data that follow the from-to principle. I used these dates to find the sequence and then use them to connect the related points to each other. Even though I was able to create convex from the related points, the built convex were linearly connected.What I would like to attain is to find a method that can link the points based on the road alignment. I gave the point-to-line-overlay transformer a try, but it was not successful! I think the problem was basically because of not having attributes that could be used for grouping!If that was the case, does anyone know how I should assign an ID counter for the features that fulfill a certain

I have used SchemaMapper successfully with CAD to GIS conversions but apparently CAD to CAD is different. The output DWG has all the layers in the DestinationLayer column of the crosswalk.xls as well as the SourceLayer layers. No redefinition takes place.

Is it possible to auto assign different point fonts based on table data. ie. assign differnt points to pit, pole, electrical, water ect. I have a .tab to edit. I have some blocks from autocad, it is possible to use these? Would

Hello Sir / Madam, So I have a CityGML (.gml) 3D model, it has three layers - Bridge, BridgeConstructionElement and BridgeInstallation. I am just wondering is there any way that I can merge all layers into one single 3D model? As I will have thousands of models that might be divided into different layers, I need to find a way to group all the layers for each model. Then, I can analysis the data later. I tried "Deaggregator" and "MeshMerger" but it seems like it is not working.I would really appreciate if anyone can give me a hand. I have attached a sample data below. Thank you very much.

HiI tried to read this website https://stilo.comune.torino.it/albopretorio/#/albo/59 but in the response body I don't have the info Pubbl. N°Atto N°Dettaglio (probably some javascript are present but I' not an expert..) How can do this ? thx Francesco

Today i use the datetimestamper to have my date in a string, but i want to convert to an attribute Thanks in advance and sorry for my bad english ! 🙂

Has anyone had any luck with Date/Time in the Chart Generator?

With the CAT reader, I'm loading a text file many small numbers, some of which are automatically converted to scientific numbers in the Visual Preview. These then become impossible to work because, for some reason, any transformations of the data are based on those scientific numbers rather that the decimal numbers. Is there a way to disable this automatic transformation from decimal to scientific numbers?

Hello, I am reading some attributes from a database. Some are in string format, some in number (int, float etc.). I want to write these attributes to a json file.I noticed that all the attributes in string format are automatically output in quotation marks and the numbers without. In my case I have three attributes: district, lat and long. District is an int, lat and long are strings. How can I change lat and long so that their output is also without quotation marks like the district one (see image) ?

HiI need to extract the 1 2 3 4 5 td element inside class paginated_element in separate rowCan you hlep please ? I'm able to extract the entire class but not the single value thxFrancesco

I have been given the task of creating an e-mail function. It should send an email when another date is about to expire. For example, a customer receives an email when there are 14 days left on their current booking. But datetimecalculator does not work to calculate intervals of days when it comes from ESRI file geodatabase (is SDE in the original data) I suspect it is the format of the attribute that is incorrect but can't find how to change it to a working date. Is there anyone who can help me? Attaching my workbench and a file geodatabase as a zip file Best regardsJesper 

I am getting some strange spikey artefacts from ContourGenerator. The dataset is a goverment isued DTM, pictured are some sea islands. The data is preprocessed with rastercellrounding and a notatasetter to ensure that the sea surface did not hold any data.  Settings as follows:First image elev 2.5 tolerance 5Second image elev 2.5 tolerance 0Third image is a close up of the the second (elev 2.5 tolerance 0) Any ideas on how to deal with this?     

(I have attached the dataset)I have survey points where each point is less than 2Metres from the next point per run, in a run i can have more than one section, as shown in the attached file, but all the points within this one run are still within a distance of less than 2M from each other. The difference in distance between runs is more than 2M. So it is evident when a new run starts and ends. If i had the attribute run within my dataset i would use the linebuilder and create lines from points.So what i am trying to achieve is to group the data per run. So far i have tried creating a new attribute in the Attribute creator transformer using conditional values but to no success. Anyone with an idea of how i can achieve this? Thanks,Keller.

Using Workbench 2022.2 and try to insert a TIF into an existing mosaic dataset and FME is returning the error: Unable to retrieve path to raster dataset from feature Yet, I can see the fully qualified path to the TIF in the incoming fme_dataset attribute from the geotiff reader?

What is the best way to download data from an Open Data ArcGIS Site that does not require a login?

I have roughly 12.000 features (points). Each feature has a list with 400 elements, which all have an X and Y attribute. I would like to remove the elements of which the distance between the point of the feature and the element attributes is bigger than a certain number.  Currently I'm first exploding the list, and then using a tester with the arithmetic expression(@sqrt(@pow(@XValue()-@Value(x_end),2) + @pow(@YValue()-@Value(y_end),2))).  The problem is that this way I first explode the list, which results in more than 4 million features! If I could eliminate them before exploding than I would only have roughly 200.000, which would improve performance.  

I will soon have two sets of (hopefully) identical data to check against each other, sat in FGDB's. There are quite a lot of records (thousands, if not tens of) and I'm looking for differences in any attribute between the two versions of the same record.  I can see this taking a long time, and note there are different options within FME, including Matcher, CRCcalculator, etc. What is likely to be the most efficient method?

How can I assign a unique identifier to all areas that intesect each other?