Transformers

Hi all/season greetings, I am trying to figure if this is best to use SQL or FME.I have two excel files which look like this below. I want to join the tables together and then produce a extra column based on the changes column. The join bit looks fine.The next step is the Extra column should be created based on if the changes column either contains a value or not. If it does then it spits a output and if it does not it also does. Only issue i am unable to how to get logic so when you join them based on the record number, you then base the 'extra column' on the changes column being populated with a value.Description of extra columnExtra Column Title = Status - will be the name of the column.It then should be able work out based on record number if the changes column has a value in it. If it is empty then the output to that column should be 'not completed' and if it does have a comment then it should come up as &#

Hi,I'm trying to combine two data streams based on keywords. (chain)   How can I do this? Thanks, Ed  

i dont know how do it, i see some discussion here but i dont know what i do wrong.the input the worckbench

Hi. I have a multipoint shape file of Dissolved points on the basis of locality. I want these points to be enveloped with the polygon on the basis of the locality.

Hi All,   I am currently trying to extract links from an HTML page, but it has them embedded inside a javascript toggle. The current workflow I have used in the past uses the HTTPCaller, then uses the HTML extractor to pull out any links using: CCS Selector = a[href] and Tag Part/HTML Attribute = href. It then uses the ListExploder to put all the links into a table. The problem I am running into is that on this page the links I need to pull out are inside a link that is <a href="javascript:toggleObj.()>. When I look at the HTML after the caller it does not show any of the links that are inside of that toggle. Anyone have any ideas how to pull these out? I have attached a couple images to illustrate the problem.   Thanks in advance! -Adrian  Example of the link I need to pull out and concatenate: HTMLE

I would like to use the Tiler transformer to create 100x100m tiles. How do I specify this? They only size option I see is listed as "ground units".

i need transfomer to gdb with raster to ecw. and i need pass from RGB to Grey.

I have an AttributeCreator that is meant to create a new attribute called "regDate" with the value:@DateTimeParse(@Value(supByRegPlanDate), %Es) The output for regDate is the string: @DateTimeParse(1543293100000, %Es)However, I am expecting an output similar to: 20181127043140Any suggestions why the output is showing the expression that had obtained the value from the feature, but, not created a DateTime?  

I'm working with CodePoint Polygons (areas for Postcodes) and have developed a Workspace to count addresses in each Postcode that are inside and outside a certain area. I'm using AreaOnAreaOverlayer to split the polygons into 2 where they cross the border of the other area. However, the consquence of this is that Vertical Street* polygons get merged (I think the Tolerance parameter is doing this), which causes one of the Postcodes to be lost. This means I don't get an address count for it.I've tried using Group By Postcode, but this crashes the process because there are too many unique Postcode values. A WorkspaceRunner to process each Postcode separately seems overkill. I can do it by Using Attributes From One Feature, creating a List of Postcodes, then using ListConcatenator etc to re-create the deleted polygons after AreaOnAreaOverlayer has merged them. But this seems a rather tortuous way of doing it.Any suggestions?* a Vertical Street

I am attempting to remove extra spaces and other characters from a attribute entries. I was able to find small script that does the job but in python. For Example:point_NAME (Before Processing)A B C Bank , DreamTownpoint_NAME (After Processing)ABC Bank, DreamTownI am able to detect the points which have these extra spaces and I am attempting to pass these on to pythoncaller transformer.I want to use this syntax in python caller. Can someone help me out? import restring4= "POI_Name"print (re.sub(' +', ' ',string4))  Thanks for all the help in advance!! :)@takashi @david_r @Mark2AtSafe @MarkAtSafe

Hi All,I'm trying to apply geotiff imagery to 3d roof geometry with the Top Down Georeferenced method (using Attribute Join within the transformer). The geometry is rejected and encoded with the MISSING_REFERENCEE_KEY string.Any help is much appreciated!Thanks,Charles

I have built a workbench where I do some processing on a set of features and then test the result. If the result is not what I want I would like to go back to the original feature and send it down a different path. How do I do this? I know how to find duplicates, set counters and such, but how can I compare the attributes from features in two separate "data streams" and then output one of those "streams"? Apologies in advance for what is probably a very simple answer, but my Google-Fu failed me this time.

Hi all,  I need to build a nested Json structure similar to a folder structure. Is it possible to do with the JsonTemplater wihtout a lot of sub-templates? I want something more dynamic or alternatively I have to post-process the Json.  Thanks!  /Jacob

I am using a FeatureReader to connect to our SDE GDB. I want to add a query (WHERE Clause) to the FeatureReader so that I am only pulling in records within the Feature Class that were edited within the last month (or sometimes edited in the last 5 days).When I look at the SDE data via MS SQL Server Management Studio (SSMS) vs within FME's Data Inspector I see the data in different formats:Within SSMS - LAST_UPDATED field is a DATE field:  last_updated (datetime2(7), null)  2018-12-01 16:23:56.0000000Within Data Inspector - LAST_UPDATED field is STRING field:  last_updated (string)  20181128133118My questions:1) is there a way to specify which attributes I want to be brought in? Right now I am using an attribute manager to remove the unwanted attributes.2) How do I only at a WHERE Clause so that I only pull in the data I want within the specific time range? I have tried "last_up

Hi all,I have a question a bout spatial join.I have 2 folder data. Folder 1(GA Folder) and Folder 2 (CHANGE REGION).I want to join spatial each file in folder 1 with a file in folder 2 which the same date.Actually, I can use testFilter for each date but it's manual. So I want to use other way to make it automatically. Could you show me how to the way to make it?Thank you

Hi,I am trying to flatten information stored in XML into a tabular structure. Some attributes can be repetitive (for instance a water area name can be provided in different languages or different alphabets). My guess is that the XMLXQueryExploder transformer should be able to play a role there or maybe simply a ListExploder. I guess using a XQuery would be more appropriate but I didn't figure out the appropriate syntax yet. Basically I would need to extract the name information from the attached XML and populate these into a tabular structure such as shp or gdb table. The desired layout would look like: FeatureIdNameTypeISOLanguageCodeLanguageCodePrimaryNameIsoScriptCodeNameTextNotationAlphabetGeoActionTypeGeoView93e05831-25b5-4df2-b264-179c9b7914b2StandardNameENGEnglishTRUELatnPersian GulfLatinRemoveZAL93e05831-25b5-4df2-b264-179c9b7914b2StandardNameENGEnglishTRUELatnArabian GulfLatinAddZAL93e05831-25b5-4df2-b264-179c9b7914b2StandardNameARAArabicFALSEAr

Hi I am trying to run an SQL to select records in past 10 mins from OracleI have tried various methods in my sql, but none seem to workselect * from table name where updatedtime >= sysdate - interval '10' minute select * from table name where updatedtime >= to_char(sysdate - (10/24/60), 'DD-MON-YYYY HH24:MI:SS')I am thinking of setting a parameter to the required datetime and use it in SQL ServerCouple of queries:1) Is startup script best place to create this parameter2) Will SQLCreator query work with a parametere.g. select * from table name where updatedtime >= to_timestamp(fmeparameter, 'DD-MON-YYYY HH24:MI:SS')where fmeparameter ='14-DEC-2018 14:00:00'

I don't see any readers or writers for Mapbox datasets and was wondering how you can manipulate. Trying to manipulate the vector data in the map opposed to the Tiles. Any help would be great, thanks.

I have a mesh example which I'm trying to simplify with the MeshSimplifier. When using certain different Settings I get either a mesh or a rejection message. In the attached example the mesh passes when using 0.5 as the Relative simplification amount. When set to 0.2 I get an invalid mesh. Also when using the result form the MeshSimplifier.Can anyone tell if my mesh is invalid or if this is just FME behaving badly? If it is the mesh does anyone know if there is a way to fix it?  Example:

HiI wanna try to convert building footprint shape file to cesium 3dtilesBuilding footprint shape file has attribute of Building Floor informationAttribute field name is 'GRO_FLO_CO' Check it under imageand i need to attach shape to DEMI use 'SurfaceDraper' and Extruder from floor attribute.I want to display different color of 3D building surface according to building floor.I use appearanceStyler and AppearanceSetter but they didn't work.Only AppearanceSetter Work.This is my Workbench<Workbench overview> <AppearanceStyler Setting

I'm trying to convert ISO datetime to FME DateTime in 2015 version. Have tried using DateFormatter transformer but gives wrong output. It is strangely displaying Expected datetime+02:00 hrs. It looks like it may work in other versions, but not in 2015. Not sure what the issue is.For ex: The value 2018-12-13T22:05:36.000Z (ISODateTime) gives 2018-12-14 00:05:36 instead of 2018-12-13 22:05:36Any suggestions please? Thanks in advance.Tagging @takashi, @david_r.   

I am converting a kml to shp and trying to calculate the area of the resulting polygons. It seems to run okay, but I don't see the calculated result. The field that should have it is blank in the attribute table in ArcMap. Here is the AreaCalculator transformer: This is Inspector:Is it actually doing the calculation? Where is the result?Thank you..

HiI am trying to create drive time zones for a data set with 2-5 starting points, much like image #2 here, http://desktop.arcgis.com/en/arcmap/latest/extensions/network-analyst/what-is-network-analyst-.htm. I read https://knowledge.safe.com/articles/30048/creating-time-and-distance-isolines-using-the-netw.html and I managed to create drive time zones for a single starting point:Each zone is 3 minutes of travel. However, I am looking for a solution for using multiple starting points. The idea is to see what happens to drive time when adding or removing points (clinics, in my case). Any suggestions on how to

Result of duplicatefilter unique port is always 5000 features, irrespective of the number of input features.Is there a kind of FME default value of maximum features I have to change/increase?

Hello,We are trying to connect to a Naviline billing system that is used for water billing for the first time that has an IBM DB2 database with an i IBMDA 400 server. I saw this web page that was posted on June 1, 2016. https://knowledge.safe.com/articles/675/creating-an-odbc-connection-to-an-ibm-db2-database.html After reading this I am thinking this is the process to make this connection. The post is a couple of years old. Has anyone tried this process recently? The .exe file mentioned in the article is v9.7fp1_nt32_client.exe. Is this still the case or is there a newer one?Thank you in advance for your consideration.Laura