Using transformers to modify data.
Recently active
Hi all,Hopefully a simple question! I have a custom transformer that I have exported to a FMX as it contains blocking transformers and looping. I want to use the iteration count value to calculate another attribute value but I cannot for the life of me work out how to access the iteration count attribute from within the workspace. Thanks for your help.Cheers,Barrett
Hi All, Has anyone used Mapnik Rasterizer transformer for OpenStreetMap Raster Tiles. I have used other raster tile sources with success by rendering them with Mapnik Rasterizer; unfortunately, I am not able to find the cause of OpenStreetMap output being totally blank or transparent. Before using this transformer I am able to visualize it within Inspector so I am confident is something to do with the rendering I am using for this specific raster. Thanks,Ana
Hi All, I am trying to merge several raster tiles into a single one using RasterMosaicker. Unfortunately, in the output raster you are able to see horizontal and vertical white lines as well as a horizontal black line at the bottom. Please note these are not present after georeferencing the tiles and is only after the used of the RasterMosaicker transformer that they appears. Is there a transformer I need to use prior this or are the parameters within the RasterMosaicker the ones need altering? Any ideas welcome! Thanks,Ana
Just wanted to check before I put something in place to handle it. Is there anything in either the Date/Time Functions or Date Time Converter that allows you to specify that 1 year on from the 29 February 2020 is the 1st March 2021 rather than the 28 February 2021?
I have an xml with the following structure: <?xml version="1.0" encoding="UTF-16"?><Report> <Category> <Category Empty="10" Name="T" Type="Filter"></Category> <Category Empty="30" Name="S" Type="Filter"></Category> </Category> <Fase> <Fase Empty="1" Name="AO" Type="Filter"></Fase> <Fase Empty="2" Name="VO" Type="Filter"></Fase> <Fase Empty="3" Name="DO" Type="Filter"></Fase> <Fase Empty="4" Name="UO" Type="Filter"></Fase> </Fase> <Imago> <Imago Empty="1" Effect="Low risk" Score="1" Type="Quantifier"></Imago> <Imago Empty="2" Effect="Moderate risk" Score="2" Type="Quantifier"></Imago> <Imago Empty="3" Effect="High risk" Score="3" Type="Quantifier"></Imago> <Imago Empty="4" Effect="Extreme risk" Score="4" Type="Quantifier"></Imago> <Imago Empty="5" Effect="None" Score="0" Type="Quantifier"></Imago> <Im
I have a template with differents divs with id and class, I want to delete or remove them with javascript code, I am not sure if I should use javascriptCaller or if there is another way to do that, if javascriptCaller is the right way, how can I do it? if not what the other option is and how I can do itThanks
Hello,Is there a method to combine a STANDARD TEXT with the VALUE of a PARAMETER and use thia as the NAME of an ATTRIBUTE?The value of the parameter varies with the loop.Ie:TEXT : DAYS_PARAMETER-VALUE : 2017, (next time) 2018, , (next time) 2019 So I want to name the new attribute:- the 1st time: DAYS_2017- the second time: DAYS_2018- the third time: DAYS_2019- ...etc. The value of the attribute is calculated by DATE_END-DATE_START in days.So the output looks like this:NumberFile DD_START DD_END DAYS_2017 DAYS_2018 DAYS_20195124 20180101 20200131 0 365 31 Please response if it is not possible to make an ATTRIBUTE_NAME while looping with parameters.(I also tried the AttributeDereferencer and attribute exposer and other transformers without succes.)Thank you,Perry
Hi,I want to create a custom transformer that concatenates the elements of a list entered as a parameter. This list is like: elements {0}, elements {1}, elements {2}... elements{x} and contains words. The start index is also an input parameter. As the number of items in the list varies, I created a loop where I get the index of each item.My problem: my list $(_ list) is a parameter and I don't know how to call its elements to add them to the string I want to build.Can you help me?Nicolas
I have a Workspace with a CustomTransformer that get Input values, Uploads file via SSH to a MFT (managed file transfer, fancy ftp server), generates a unique link for downloading. I can't use WorkspaceRunner/FMEServerWorkspaceRunner, it can accept Input values but only returns a basic successful but not the unique link. I started to create the FMX so I can save the CustomTransformer on FME Server to be used as a LinkTransformer. I'm not worried about users using the CustomTransformer, but I would prefer users not seeing the password for the upload accounts. QuestionI there a way for me to scramble the password so the users of the CustomTransformer can't see the password?ORWebhooks and create an API so it could use by anybody?The idea would be any FME Workspace that needs a file upload would HTTPCaller, FME Server URL address (Webhooks) with Query String of Input values and then I think a Data Streaming Service to get back a JSON or HTML?Can Webhooks be use without a Token
Adding cost attribute : i have specific attribute and i would like to find the path that has the lowest value of this attribute ,even if it is shortest path or longest path ,does not matter of the length .i tried to use Cost type by one attribute ,i did not get any paths so i used by two attributes and i get output but it goes through two paths . one path has cost attribute=30 ,and the second path has cost attribute = 60 ,i did not understand why it goes through this path that contains 60 . i thought ,it will goes only through path 30 . secondly ,i was watching videos about shortest path finder and i did the same parameter for attribute value mapper but i did not understand why should i make the parameters like that ,default value 2 ...why will be better for Cost to use two attributes instead only one attribute ?i need only to get one path that contains lowest cost of attribute ,how could i achieve that and does not matter of the length ? the network is noded correctly ,because i used
Hi, I have 399 polygons that I want to dissolve on their nearest neighbour. I'm using the spatial relator to create an id between the polygons to be dissolve and the polygon they will be dissolve on. In the vast majority of instances when I run these polygons through the spatial relator it works. For example if a polygon to be dissolved touches another polygon it will get a shared id. But in some instances where I can see that the two polygons are touching I'm not getting an id created between these two. Would anyone have any idea why this is happening? I can share any details through screenshots, just ask.Thanks for any help. B
So, I am working with a river linear dataset. I am assigning an ID to every river that all of the unique features of the river share. But, the issue that I am having is that there are some general names and one name is shared between 50 different streams (that contain 350 features). I located most of the using NodeValence and FeatureCounter where I group by name and valence 1. However, I cannot distinguish with 100% certainty which rivers are different even when they share the same name so that I may assign them different river IDs. I would need to include coordinates or similar. Any idea? So, I am using the aggregator to aggregate by name, creating a list of unique IDs and appending the same ID to same named features. But the problem is that some same-named features are actually at different locations so I need to separate these and provide a separate river ID.
Hi, I have several XML files with the following content: <gmd:contact> <gmd:CI_ResponsibleParty> <gmd:organisationName xsi:type="gmd:PT_FreeText_PropertyType"> <gco:CharacterString>Information in main language</gco:CharacterString> <gmd:PT_FreeText> <gmd:textGroup> <gmd:LocalisedCharacterString locale="#ENG">contact info in English</gmd:LocalisedCharacterString> </gmd:textGroup> </gmd:PT_FreeText> </gmd:organisationName> </gmd:CI_ResponsibleParty> </gmd:contact> I will like to add contact in other language, for example: <gmd:contact> <gmd:CI_ResponsibleParty> <gmd:organisationName xsi:type="gmd:PT_FreeText_PropertyType"> <gco:CharacterString>nformation in main language</gco:CharacterString> <gmd:PT_FreeText> <gmd:textGroup> <gmd:LocalisedCharacterString locale="#ENG">Cont
Hi, this is a really basic question, but none of the other answers I've read have quite fit. What I want to do is simple - find the percentages of these two values:The answer would be NoBlank - 78.22% , BothBlank - 21.78%I'm aware the trick is to find a way to sum the Individual ID.total_count column in the Expression Evaluator, but "@sum@value(individual ID.total_count)' doesn't work, only returning the original values. This so frustrating because I'm sure it's very simple.
New for FME 2020.1 is data-aware transformers. When data is cached via Run with Feature Caching, the attribute values can be retrieved from within specific transformers. Retrieval of these values will prevent any data integrity issues that occur with spelling mistakes and makes the workflows faster as you don’t need to keep viewing your data to get the value you want to test for or expose. This feature is currently available in the Tester, TestFilter, AttributeExposer, and anywhere that test clauses are used. How to Use this Feature1. Ensure that you have FME Desktop 2020.1 or later installed. Then read in your data. Run the workspace with feature caching enabled. This step is key! 2. Add a Tester, TestFilter, AttributeExposer, or any other transformer that uses test clauses. Once connected, open the parameters. In the parameters, select the Left Value attribute. For this example, I’m using Common Name. Then select your Operator. To retrieve the cached attributes, click on the dro
For example, the user has selected 4 dates in this order:We wish to retain this date order for the output table, but after running the formatted dates through the AttributePivoter to set the dates as attributes, they come out in alphabetical order, as follows. Note that dates 3 & 4 have switched. The order of attributes should be Jun 2019, June 2020, Sep 2018, Mar 2019.Has anyone managed to deal with this issue?Thanks in advance :)
Hi, I want to count values for individual fields in excel. There are 110 fields. I want total counts column by column for all values that are not missing, empty, or null.
Hello,I have a little problem and I hope you can help me.I use the transformer xmlTemplater. It works fine. But there is one problem:If I insert an attribute with "<" or ">", the Transformer will change it in "lt&" or "gt&". Is there any option, that the transfomer doesn't change the attribute?
Dear community I have just started using FME. I have an excel sheet with some x,y coordinates in the danish s34 (DenmarkS34-S) that i need to reproject into ETRS89 zone 32. I have tried using the attributereprojector but the coordinates i get are incorrect. I have also tried the csmapattributereprojector, but i cannot find that particular transformation. I hope you can help. Regards--Rasmus
I have a list of connections (ServiceID) that are attached to a main (MainID), that are grouped by a network ID (NetworkID). There can be one or more connections to a single main, and there can be multiple mains in a network. See example -I need to list out the mains with all possible service connections within a network. Each main ID would have all connections within that networkSo the above example needs to turn into this -I thought I would be able to use a feature merger, or joiner, grouping by network ID, with both requester and supplier coming from the same table (kind of like a many-many join) but that doesn't seem to work. Maybe my parameters are off, but I am not even sure if my logic is on the right track. I am somewhat new to FME. Any suggestions would be welcome!!
Hi everyone,I really appreciate the data inspector for z visualization of point cloud, but I can't find a way to plot or see a color bar / color scale to easily read wich values are associated with wich color. Is there's a way / trick to do this ? Thanks !
I have a folder with soil shapefiles. The schema all vary slightly and I want to merge them into a new schema. I can only connect one field to the output field. So for example, here I want to have 'PCT_A' and 'A' loaded into the output shapefile 'PCT_A' field. Can this be done?
Hi everyone,I have an output from a PointCloudCombiner with 4 components (x, y, z, _distance). The _distance attribute comes from a NeighborFinder. What I want to do with the point cloud is to replace the z component of each point by its _distance value. I tried to use the PointCloudExpressionEvaluator after the PointCloudCombiner but _distance doesn't appear in the component list. I only have access to it as an attribute (not a component) and then get the same z value for each point of the point cloud... But when I check the PointCloudCombiner output in DataInspector I can see by clicking on each point that there is a _distance component that changes with each point. How can I have access to this component for further processing ? Thanks !
I have a feature type of polygons, namely A, and want to use it as the candidate in a SpatialFilter against another feature type of polygons as the filter, namely B. B consists of a few groups of polygons, each group has an unique group name. What I want to achieve is like looping through each group of polygons in B as one filter against the same candidate of polygons of A. I see the SpatialFilter has a "group by" parameter but it requires both the candidate and filter having the same group names, which is not the case here for the candidate. Seems a simple and reasonable scenario, but I can't figure out a way to do this. Any advice or hints are welcome.
hello,I am trying to write inside an xml file elements only if a feature attribute has a value.I have 2 shp files :In first file I have "Eticheta" feature with names of the street.In second file I have "label" feature with attributes values are the same as "Eticheta " from the first file. Here, in the second file I have also "NR" which. I am trying to write in XML numbers for streets and I need to write the numbers on each street.I used an if-then-else statement that writes out the numbers only if street from first file is exactly like street from second file. in my XMLTemplate, in subtemplate I have: { if( fme:has-attribute({fme:get-attribute("label")}) eq fme:has-attribute({fme:get-attribute("Eticheta")}) ) then {fme:process-features("ADRESA")} but fails to write data inside xml file.errors from log:XMLTemplater (XMLTemplaterFactory): An error occurred while parsing the 'ADRESE' sub-templateXMLTemplater (XM