Transformers

Hi all,If have an issue creating a unique column for a range of points. The points are separated (based on calculations) in ranges that run from 3 to 2, all the point within this range have 1 values (for example 3,1,1,1,2). I would like to generate a new column containing for each range an unique id. See my example columns down below, showing the preferred result:UUIDRangesPreferred ResultA31A 11A 21A - A 32A 12A 22B33B 13B 13B 23C34C14 Is there a way to calculate this final column?

I am looking for the equivalent of ArcGIS ModelBuilder's "precondition." I am using the AttributeExposer transformer and I need to enter a table that contains all the values I want to use for the attribute names.The names come from a field in the input table, and I don't know how many there will be beforehand, so I need to generate a table which is then read by the AttributeExposer.Is there any way to ensure the AttributeExposer does not try to run before this table has been created?Since the table is created with a writer, there is no output for me to plug into the AttributeExposer - It is a "dead end" on a different branch.Thank you,Randy McGregor

Is there any SQL transformer that doesn't need any initiator but only needs a trigger/input to connect to previous step? I don't need SQL Executor which requires an initiator that involves in the query. I can't use SQL Creator because it doesn't have an input handle that can connect to previous step sequentially. any advice?

I've been trying to figure out how to include an external application in my FME Desktop transform. Recently I discovered that my target application exists in the PYPI repository and I believe that these projects can be run in FME.From what I have read, it looks like I can implement this application in FME using Python Creator/PythonModuleInstaller/ PythonCaller.How do I setup and use a transform based on a PYPI project? My experience with FME is limited.https://pypi.org/project/sutime/ Thanks,Gilbert

I have a SQLite database (version 3, created in FME) that I want to use a Select statement with a regular expression in the SQLCreator transformer. According to the SQLite documentation the regexp() user function is a special one that need to be defined. Does anyone know a easy way to do this in FME? (it have to work in both PC and Mac environment)

Hi all,So, I've got this small data set of 12 locations in the Netherlands.  I would like to create a distance matrix that tells me what the distance (as the crow flies) is between each point. I figured that I could use FME for this. I think I managed to get quite far, but now I'm stuck and in need of some assistance :-(.So what did I do so far?  I first created a workspace that reads the data set and then uses the FromToBuilder transformer in combination with an AttributeManager transformer to determine distance from one manually selected point to all other points. A csv-writer writes the resulting table to a csv-file.  Secondly, I added a new published parameter in combination with the Workspace Runner transformer to run through the 12 points. So that I don't have to run the workspace 12 times and manually assign a point to the to-port of the from-to transformer.  This generates a csv-file of 12x12=144 features.   I'm no stuck figuring out how to convert the 1x144 tab

I want to put the line connection the Center point of rectangle?I dont know how to do?

Hello I am trying to create a control for foreign key integrity constraint between 2 tables.it is a simple case of referenced table and referencing table. I want to check if the reference value is exiting or not.What is the simpliest way to realize that opération ?thanks

green is rectangle?I want to get the all red line ,Which converter to use?

I am trying to merge two lot of attributes but when using FeatureMerger, it is only picking up the requestor attributes and the Supplier attribute of 'issue' keeps repeating '36'.ThanksBill

I have a workspace that has multiple line segments and several overlapping polygons, I would like to clip the line segments to the polygons without gaining or losing line segments in the polygon, I have tried cloning and also geometry replacement and spatial relator but I always end up with merged line segments inside the polygons after clipping. Some of the resulting lines that are clipped span the entire length of the polygon. Here is what I am currently attempting, I am using method from this answer in the forum. I have the parameters set the same as in the post made by takashihttps://knowledge.safe.com/questions/90178/clip-line-for-each-overlapping-polygon.html  

Has anyone ever encountered an issue where the ShortestPathFinder fails to find a route when multiple From-To Lines enter the transformer but with no issue when the same single From-To Line is considered in isolation - never encountered this before and not sure how I can resolve it...

Hi,  I am trying to build a workbench that transforms SHP data to DGN files. I have a huge amount of shp files, each one with the same attributes. Despite this, in some cases the width of char type Attribute "ID" is not the same. Mostly width is 20, but in some cases I cannot predict this value.Right now I have an issue when the ID width is not 20, because shp reader is defined this way and I get an error.I would use a single workbench for all SHPS. How to make reader accept multiple ID width values?      Best regards,Pol

Hello everyone,Im thinking about the best way how to check encoding of ASCII (.txt) file in FME Desktop.But, is is possible, at all?Now, I have TXT reader in my workspace nd then I use stringsearcher transformer to check unsupported letters. Im not sure if it is the best way...Thank You so much!Lubo

I am trying to calculate time difference (in minutes) between two values using the DateTimeCalculator. Both are in the format %Y%m%d%H%M%S and have been run through the DateTimeConverter. The workbench completes when run on FME Desktop but when i upload and try and run on FME Cloud im getting the following error.

Good afternoon. I have one raster with 4 bands (RGBA). The alpha band shows transparency (255 is transparent and 0 is opaque). Furthermore I have another raster that I have to multiply with first. Is it possible to extract any values (i.e R=179,G=227,B=249,A=255) and set alpha band as 0 (opaque) and leave the rest of raster with its original values for multiplying later?Thank you at all.

As shown in the figure, the arrow (the start point of the line segment points to the end point), how to calculate the coordinates at the red point?

Hello,I'm here with a problem that I saw elaborated in other posts. I tried to apply some hints from there but unsuccessfully. The problem I'm facing is to assign Z values to geometries vertexes, taking them from other close ones, interpolating the values considering the distance (measure).I tried with MeasureOrZvalueInterpolator but, sure because of wrong understanding of the transformer, without any results. Is this a problem to solve only coding?Any idea, hints or already implemented examples?TIA

I need to transfer a point shape file into an annotaion layer inside a gdb. The point shape file doesn't have z value, and the target annotaion layer has z value.when I run the task,it shows an error as following:An error occurred while attempting to set the 'Annotation' property on the 'IAnnotationFeature' interface for the annotation feature class 'ANNO_I'. The error number from ArcObjects is: '-2147467259'. The error message from ArcObjects is: {The Geometry has no Z values}If I create a new target annotion layer without Z value, it will be OK. For other simple layers which also have Z values,no errors occurs.So what can I do to transfer the shape file into the annotation layer?

Relatively new FME 2018 user and just trying to see if there some improvements to my use of Tester in the workspace. Now, I've been using Tester a lot to do simple things like using it like a WHERE condition, but in 2018 at least it seems to do a naive, feature-by-feature test of the Tester conditions. For example if I use Tester on a 2M feature input with a condition AttributeValue = 'A', then this takes around 2 minutes to complete.However, I've later discovered FeatureJoiner as a go-to transformer for significantly better performance as this seems to first index the Attribute(s) in question first before testing them, as well as passing out the Unjoined features without any post-processing overhead as essentially "untouched" features.If I instead use an alternative of Creator(1 feature)->AttributeCreator(Set AttributeValue='A') to make a single Test Feature, and then pass this into the RHS of a FeatureJoiner transformer to test against the 2M feat

I have a spreadsheet with columns of data that need multiple match criteria to merge (using FeatureMerger) with SQL DB records, then within the spreadsheet, there are 2 columns for Start and End Date ranges, and within the DB records is a specified date/time. What would be the best way to merge the Features from both sources, matching the other criteria as an exact match, but matching the date to a range?

I am passing a date UserParameter into a workbench and am then trying to convert it from the standard FME format to dd/mm/yyyyParameter is formatted as yyyy-mm-dd and if I just use the Parameter the value unformattedit outputs as yyyyddmm eg 1950-01-01 becomes 19500101I want it to output in dd/mm/yyyy format but if use dateformat($(PositionEffective).%d/%m/%y) a null is returned. Thanks in advance

Bonjour,J'utilise un Jsontemplater pour integrer des données dans une base <Mongodb.Le format date est requis pour effectuer des calculs ultérieurs.Probleme: toutes mes dates sont en string.Est il possible de forcer le format date dans je _result ?Merci

Hye, I want to ask on how to delete areas with certain size ya? The data I use is vector data. I hope u guys can help me. Thank you so much

I have an old but simple workspace with one private parameter defined as return FME_MacroValues['pEvent_Attributes'].replace(',',' ') + ' ' + FME_MacroValues['pEvent_Route_ID']When I dug it up and run it under 2019.1.2.0 (20190829 - Build 19630 - linux-x64), it failed with the following msg:Python version 3.6 loaded successfullyTraceback (most recent call last):  File "<string>", line 5, in MF_Include_1574806112377  File "<string>", line 4, in ParamFuncKeyError: 'LRS_EventMerger_pEvent_Attributes'INCLUDE -- failed to evaluate Python script `def ParamFunc():  return FME_MacroValues[FME_MacroValues['LRS_EventMerger_WORKSPACE_NAME'] + '_' + 'pEvent_Attributes'].replace(',',' ') + ' ' + FME_MacroValues[FME_MacroValues['LRS_EventMerger_WORKSPACE_NAME'] + '_' + 'pEvent_Route_ID']value = ParamFunc()macroName = FME_MacroValues['LRS_EventMerger_WORKSPACE_NAME'] + '_pAttributes_Merge'if value == None:  return { macroName : u'' }else:  import six  try:    value = six.text_type(value)