Using transformers to modify data.
Recently active
Hi,I would like to break a line into segments and then assign a sequential order attribute starting at the start of the line.For example, in my screenshot, if I break the line into 500m segments, I would like section 1 to go from the start point to 500m, section 2 to go from 500m to 1000m, and so on to the end of the line.I've tried using the iterative snipper and the chopper to break the line but the problem is that they both output the line segments in a random order.Would anyone know how I might do this?Thanks.
I have a FME project reading information from an API and writing to an excel file. In the project i have a tester that tests if the data belongs to a certain organization. The organization list might expand, so I want the tester read this data from a (excel) file. How can I do this? Can I loop the project from the tester and write to different files?Thank you for any views on this.
First datasetI created about 1 million lines between 1565 points. These points are locations and the lines are possible routes over a network between the locations. Many of these lines (=routes) overlap each other. This is my first dataset.Second datasetMy second dataset consist also of lines. Part of these lines have an attribute value for attribute 'VWH' = 1. The other lines have a value of 0, VWH = 0.AnalysisWhat I want to do now is to perform an intersection between the first and second dataset. For the second dataset the features are used where VWH = 1. Using the VWH =1 features I want to intersect dataset 1 and attach the VWH value to overlapping lines. See the figure below for the main idea.First I dissolved dataset 2, for VWH =1, into one multipart feature using the LineCombiner followed by the Aggregator. The length of this multipart line feature is 7684 km.Then I used a SpatialFilter to check which features of dataset 1 intersect the multipart feature.Then I tried di
I have a block of text separated by newline characters, e.g:Some TextSome More TextEven More TextPERIOD: 01/01/1990 TO 12/12/2020What I'm attempting to do using regex is grab the entire line of text preceding the row beginning with PERIOD (i.e. "Even More Text"). In an online regex editor, the following expression successfully returns just the line containing "Even More Text":^.*$(?=\\nPERIOD)However, when I attempt to do the same in FME, it returns all lines above PERIOD. It seems as though in online editors the . includes all characters except newlines, whereas in FME it includes them? Is there a way to adjust multiline regex flags (or some other workaround) in FME to get the desired output?
I am new to FME. Is there somewhere I can download basic templates of FME projects? I am currently looking for something to count the number of files / folder in a Windows directory. I assume that is pretty basic, but I have no idea how to start. After I locate a simple template I can take it apart and learn more on how to create my own.Thanks,Dan
Dear all,I need help with task. I have two rasters grom the same place: NIR 1 channel and RGB 3 channel. I need to replace on RGB raster Red channel with NIR channel and save raster. How can i do this? Thank you on advance for help
Hey, currently I am using a centerPointReplacer to create points in the middle of cemetery plots (polygons), that meet a certain criteria (they have a photo attached to them). The points are being created in the 'Centre of Gravity Point', it works well, see black dots below, they are all in the middle of our graves:As you can see, the labels of these cemetery plots are covering the dots (or close to), and I am wondering if there is a way I can consistently move these dots to be offset, towards a common narrow end of the polygon? I dont want to use a random spot, as these will not be visually appealing, so I am hoping to move the dots to be along a common side, something like these red dots:If I can achieve this, the labels will all fall back in line and be more visually appealing.To make thinks even more difficult, I should mention that our plots are not all rotated to the same angle, they can face any which way you can think of: Has anyone had any experience doing something li
i have a Problem with the Installing of FME Desktop i have this error " pascal.filippi is a invalid short name files"
I have an odd request. My user has a data set of 758 records. They want to sample 450 of these randomly.I've completed this using a sampler with a random sampling. However, the client wants to add further columns of data to the existing random sample.If I rerun this workspace.I'll generate a new random set of data than before. How do I add a random number to a row, but keep this created number so that when I run the workspace again I get the same sample as before? Thank you!N
j'ai débuter sur ce workbench mais qui ne marche pas exactement
I have a table with integer values as one of the attributes. I need to add an attribute to represent these values as a percentage of the total of these values like in the table below. have thisneed thisvaluepercentage of total617.64705882411.76470588617.6470588238.82352941225.882352941617.64705882720.58823529 I figured ExpressionEvaluator is correct approach but Im pretty new to fme and cant see how it's done. Any help much would be much appreciated, Rgds
I have an AutoCAD file with many layers and some object data tables (ODT). FME crashes when I try to read it as a Map 3D file. I can't find out what the reason for the crash is, and it reads fine when using a regular AutoCAD reader. When I export out the objects that are just on the layers I need (most of the PR_* layers) I can then read the file as a Map 3D type. I can't tell what is causing FME to crash on the original file. I can't even read the file contents as a Map 3D type.I don't want to have to export out the needed layers all the time, what if the issue is on the needed layers next time, and I am setting up a Server app for users to use and I can't expect them to create separate files all the time.My current FME version is 2020.0.0.1 (20200316 - Build 20202 - WIN64), but I was testing an old AutoCAD file for the Server app, and it ran successfully through an older FME version back in February, but can't now.Can someone tell me what is causing FME to cra
Hi,Is it possible to populate Values of a publish user parameter of type choice at runtime using scripted Python parameter or using any other approach?
Hi there, With Covid, all our employees going to work need to fill a survey about their health status now. Every day. It's the same for kids going in summer camp for activities. So we've been asked to develop a survey that could change in time, depending on the kids that subscribed to the activities. The subscribed kids are exported into an Excel file every week. For the same activity, one week it could be 40 kids, the next one it could be 80. I thought to read the file with FME and push the kids into the survey every week. That way the list of kids in the survey could change without our help. And the kid (or his parent) could select his name to fill the survey. The issue is that we don't know any survey plateform able to change automatically from a script. Do you know if any kind of plateform could change when FME push new values into it? Survey123, Microsoft Forms, SurveyMonkey or something else? Thanks.
I need to set new timestamps to a set of polylines that is to become gpx files and have two questions:1. How do I set what end is the begining of the line?2. Is there some way to start the timestamp at a specified time? Say I wanted it to begin at 01-01-2000?
Hi. I have seen a thread in which they explain that for converting from polygon to multipolygon you only have to choose the geommetry type in the writer parammeters (on FME2019). The thing is that I can't see that option. Is multipolygon not available on FME 2018.1? If not, how can I convert a polygon to a multipolygon? Thanks!
Hi All, I have a table contains 3 fields like (id, value1, value2). In that table I have some duplicate records with combination of fields (id & value1) and the field value3 contains numeric values, these may differ or same. I have requirement like to find the largest value record from the duplicate records of combination of fields (id & value1). Can any one please suggest the approach that how to find the largest value record. Thanks, Seshu
Hi,Is it possible to get a georeferenced image/ static map from the image fetcher - or something similar?I've used the coordinates of a bounding box, and a Bing Maps API key to fetch an image but it isn't georeferenced.I've tried georeferencing it afterwards but the process completely distorts it so ideally I would like to avoid this step if possible.Thanks,
Hi,I have an attribute (string type) with values such as 37908.907836. If I use an AtributeRounder, I can reduce it to 37908.907. That's ok. But if I convert the string type to double type, the decimals comes again... I have tried to convert first and to apply the AttributeRounder later but it doesn't work. Any suggestion? Thanks!
I've been at it for a day, time to ask for some help.i got the JobHistorySnapshot from FME_SHAREDRESOURCE_DASHBOARD/temp and I am trying to create a custom dashboard and need to pivot some dataThe upper table is my input data and the lower is the desired output (i didn't add the other 4 columns for the repo_four)In words it would go like this, group by date and create columns using repository values concatenated with the existing 4 columns and also transfer the values. How could i achieve this?Thanksraw dataDateRepositoryQueuedTime.MaxTimeQueuedTime.AvgTimeFinishedTime.MaxTimeFinishedTime.AvgTime2020-05-21-17repo_one0088882020-05-21-18repo_one0030292020-05-21-18repo_two2518.511873.752020-05-21-18repo_four11729.252524.52020-05-21-19repo_one004945.52020-05-21-19repo_two2960296024256242562020-05-21-19repo_four0026047260472020-05-21-20repo_one10.16666666712049.833333332020-05-21-20repo_two0024052240522020-05-21-20repo_four002315423154
Hi, I have 2 sets of data. One is income grid (1 square mile area) other is the 50m point bin data showing point locations of potential client addresses. I need support on achieving the following:- create a polygon from bin data overlaid on income area grid and assign median income value to each of these polygons.- Polygons can be created based on the density of the clients close to each otherThanks in advance if anyone can help me with thatJohn
Hello everyone,please, I just wanna use ShortestPathFInder to find shortest path between 150 points. FME needs to get clean road (line) topology to get right path. But, Ive got road network, where are tunnels and bridges that crosses roads on surface.Please, is there any way, how to compute path which uses bridges, tunnels and roads on surface together? I have experience that FME can trace path only network at the same level, or am I wrong? Thank You so much!Lubo
Hi, i make a normal AutoCAD to AutoCAD conversion but i have Problems with circles…... circles move completely on a different place (e.g. ca.80000m to the left)when i stroke them with an ARCStroker they land on the Right Position BUT i dont want to have 2000 circles which are split into massive lines….. so anybody any helps or Workarounds?Greetz and CheersFranco
Hi.FME supports lists in both a generic format (e.g. list{}) and as lists with attributes (e.g. list{}.value).Is it possible in Python to get the latter form from a feature as a dict using just the simple format ?E.g. from a feature attribute ( list{0}.value, list{1}.value, ... ) into _myvar = feature.getAttribute("list{}") -- returning {"0":"value0","1":"value1",...} etc.Just using "list{}" returns None as is.Cheers
I am trying to use the SurfaceDraper for a project but it wont do anything. The input arrow for Breaklines is red so I that seems to be the culprit. I cant see why breaklines should be mandatory? A polyline and a DEM raster should be enough to do the draping? Is there a workaround for this?