FME Form

I am trying to go from this: to this:Where "Current Weather" is the first "validTime" record and "Next 24 hrs" is the second "validTime" record. I messed around with the concept in excel and came up with the following which might work but can't seem to replicate it in FME: I've played with the AttributePivoter, StatisticsCalculator, AttributeExploder, and others and just can't seem to alter the table to something similar to what is shown above. The idea would be to go from reading in arcgis server service features and write out to an html table (or maybe something else) which would look like (or similar to) the above table. Any ideas are greatly appreciated!  

When using a portal feature service for a table and a feature, joining them via uniqueid (guid 38) the feature joiner fails to join even though the guid is value. The dataset is branch versioned. Am I missing something?

You can export/import database connections in FMEworkbench (as xml or enc-file), wouldn*t it be nice to have the same function in FME server? Will we see it soon?

Hi.I'm trying to find the nearest polygon (city polygon) to a set of points (border posts).And I tried out the neighborfinder transformer. It seems to work fine except that it doesn't add the attributes of the nearest polygon to the point feature.What am I missing ? 

Hello, Can someone explain to me why is JSONFragmenter returning json_type = object instead of json_polygon? And how to adjust anything to get valid json_polygon? Parameters of JSONFragmenter: JSONFragmenter returns: Usually for this kind of JSON data I get (with correct geometry): JSON data for correct return is given as attachment, as well as the incorect one.  

Hi community!How can I transform a pointcloud LAS in a mesh OBJ?Tnkx to everybody

I am renaming the Postgres tables inside the SQL executor(Postgres).If the task is successful, I need a success mark or flag from the SQL executor(stored proc).here there are two flags variables in my code ie "done2" and "i"But the initiator only comes out, nothing comes from the output port. I need one feature from Result port 1 for success or 0 for failure.Can Anyone help me?CREATE OR REPLACE FUNCTION func1()  RETURNS integer AS$BODY$DECLARE   cntold INTEGER := 0 ;    cntcur INTEGER := 0;   i INTEGER := 0;   BEGIN        SELECT INTO cntold count(*) FROM @Value(table_name_old) limit 10;        SELECT INTO cntcur count(*) FROM @Value(table_name) limit 10;        --SELECT INTO cntnew count(*) FROM @Value(table_name_new) limit 10;        IF cntold > 0 and cntcur > 0 THEN            EXECUTE 'DROP TABLE @Value(table_name_old)';            EXECUTE 'ALTER TABLE @Value(table_name) RENAME TO @Value(table_name_old)';            EXECUTE 'ALTER TABLE @Value(table_name_new) RENAME TO @Value(

Hello there, So I have bunch of points and lines in my database. For the final output, I would like to extract the points/line (possibly the name) that cannot fullfill the following criteria. 1) The points MUST touch the lines, but it can have a tolerance of 1m to the closest lines.2) The starting and ending of the lines MUST have points.  So the sample shows that points 1-6 are correct, while the points 7-9 and the line below (C) are not correct. It is because the line C does not have the starting and ending points. Also, the points 7-9 do not contain lines within 1m buffer.Might I ask what kind of transformers I can use? I am not very good at FME and hopefully someone can give me a hand.Thank you very much. Zach

Unfortunately, the source data can't be obtained as one package. Instead it can only be retrieved through individual SOAP calls. As such, the workflow obtains a dynamically generated list of relevant ID numbers retrieved through an initial GET request and then uses those ID numbers to construct the respective URLs for the individual GET requests, which obtain the data that I need (but it stores the XML retrieved through each GET request as a separate record/attribute). The workflow is for a regular batch update process using the externally sourced data to update my data.

Hello #FMECommunity!Here is the news about FME for the week ending 22nd October. Community Activities: Random Acts of TransformationSo during our Community Webinar yesterday (depending on where you are and what your 'yesterday' is) Dale and I tried our hand at Random Acts of Transformation (RAOT) which is where we pick a transformer at random and try to explain it in as much detail as we can, with some lesser-known tips and tricks. Fate dealt us an XML-based transformer as our first go, which was a bit rocky, but then we gave a good description of the FeatureMerger transformer and that was a lot better. You can find just that section of the webinar on YouTube, where I hope to post more of these in the future. Community Activities: GeoguessrWe're nearing the end of the Geoguessr subscription (about 7-10 days remaining) and many users are having fun with this:  We still have a few open spots if you want to play, so let me know. Community Activities: Postcard ExchangeSo while

Hi all, Can someone tell me what the fme.uuid file is for when activating a Floating License and what the content means? Kind Regards, Krien Guijt

Hi everyone, I need to create a user parameter (choice with alias) that contains CRS used by ProjReprojector, but, in the parameter configuration, the CRS used by ProjReprojector aren't listed.I'm using FME(R) 2020.2.1.0 (20201130 - Build 20806 - WIN64). By the way, I need to use ProjReprojector because RDN2008 / UTM zone 32N isn't present in the Reprojector or CSMapReprojector list. Thanks 

Hi again, I would like to change my string containing "100000,00" to "100 000,00E". In other words, adding a space and an E in the string. I can not seem to find an easy solution for this. Thanks in advance!

HI. I have one point layer that contains residential locations. The second layer contains the location of fast food outlets. I want to create a distance weighted count of nearby fast food outlets such that:outlets nearer than 500 metres away get a weight of 1 outlets more than 2000 metres away get a weight of 0those between 500 and 200 metres get a weight of 500/distance Could anyone tell me if this is this possible in FME please?

I have an excel spreadsheet where the attribute name changes based on a formula, every time we fill in an X in line 2 the attribute has the same name, but the number can change to 1,2,3 and 4. I created a reading dynamic, but when for example the COD_STREET = 0 in the dynamic FME reader keeps showing COD_GATE = 4 in one of the attributes, what am I doing wrong? attachment follows the spreadsheet

I have a workspace which merges several Shapefiles. The filenames/locations are handed over as parameters and the workspace is called through a batch file. How can I accomodate cases where some of the input files are not present? There is no interaction between the missing Shapefiles and the other ones in the workspace, they just get written to a common destination.

Hello, I want to write features in postgreSQL. Because of a bad type of a table column some features are not written. Alert message for one of them :210 Value of attribute 'idrlt' could not be converted to type 'int4'. Feature will be logged and skippedI want them to be logged BUT written too (not skipped). Is it possible ? Thank you

Hi,  Is it possible to connect a coordinate with a street using for example NeighborFinder and generate several hits for one street if there are several coordinates close to the street? For example, if there are 5 coffee shops close to Arbitrarystreet, I want it to say that there are 5 coffee shops nearby and not just that there is a coffee shop nearby. Thanks!

I am looking for a method to remove the outcrops, circled in blue, from the building fotprints below. The generalization algorithms I have tried "soften" the polygons to much and make them look a bit organic. I would like to keep 90 degree corners as much as possible so that the viewer quickly can identity the shape as a building. It might require a different process but I would also greatly appreciate suggestions on how to fill out the "jagged" corners circled in red. Cheers! 

The extents of the shapefile bounding box are -100 (left) and 100 (right) and -200 (bottom) and 200 (top). Since there is no prj I don't know the units, but I do I know the shapefile is supposed to be a UTM 12 north map projection and I know all the other CRS parameters (so I am able to create the correct prj for the shapefile). In addition to this, I know the x-offset and y-offset and scale values that must be applied to the shapefile. My question: how do I apply the offset and scale to the shapefile? I believe these offset and scale values were derived when the file was converted from CAD. Thanks!

Does's it possible to use where clause for more than one feature type? f.e. [gas_distribution]cp_bond_wire where id > 0; [gas_distribution]cp_rectifier where id > 0Two where clause delimited with ";".

In TestFilter, is there a trick to allow specifying the list index range in the Test Clause?e.g., _list{[0-2]}.fruit = 'Apple'rather than specifying each element index to test for individually:_list{0}.fruit = 'Apple'AND _list{1}.fruit = 'Apple'AND _list{2}.fruit = 'Apple'without going into PythonCaller way?

I am trying to read in multiple files from a folder at once which contain a specific text string in the title and not any files that don't contain that string. I want it to be dynamic, such that if the files in the folder change, the reader will update as I want to put this at the start of a workflow which will put all the features from each individual source file into a single file and perform some transformations with that data. I have managed to figure out making a reader that looks at a folder and all its sub folders, but it reads in all the files in the folder, some of which I don't need/want. Is there a way I can apply a search filter to the reader so it only brings in files that have certain terms in the title?

Hi FME community, I'm creating a workspace to automate a proportional spatial sum.I have polygons with employment data.And I have bus stops that I'm using to create multiple buffers as my zones of interest. I'm testing this with zones I've already caculated with MapInfo GIS software so I know what values I'm suppose to have in the end, and i'm able to compare this with FME workspace results. I get the expected result when I aggregate all my stops points from all buses indifferently: But I also need those stats for each bus separately. To do so, instead of aggregating indifferently all points, I do it with a group by using my bus name attribute.But the results are way off.  If I add a tester before the buffer, in order to filter only one bus, I have the exact result. As soon as there is more than one zone of interest the results are false.My guess is that I don't know how to use the clipper correcly with multiple zones as clippers (even if the clipper type is

How to find the distance between two point efficiently. Have used Linebuilder with a larger dataset and it takes ages, workspace with test data is attached.