Transformers

For the life of me, I cannot find a transformer that does this simple, often-used data transformation. I do NOT want to aggregate the values when I pivot as the AttributePivoter forces me to do, and the AttributeTransposer makes no sense to me at all; I've tried about every combination of options with it with no luck. I have given an example of the transformation I am trying to achieve in the attached picture. If anyone is familiar with Power Query within Power BI, it would be the same as pivoting an attribute column on top of a values column (with no aggregation). Similarly, this could be achieved by the pandas' pivot dataframe function.  

Hi,I'm using FME to query an API. I'm passing long-lats as a comma separated value to the API, but FME is turning the comma into a url character (%2C) so the request is failing. Is there a workaround for this?ThanksN

I have a workspace which has worked previously but now keeps giving me the following error message: Attempting to retrieve global variable 'pmi_is_error' which was not set -- setting it to the empty stringFailed to create process, error was 'Access is denied. Does anyone know what this error might be associated with with or how I could approach solving it?  I've tried searching for it but haven't found anything useful so far. Thanks

This must be trivial but after long workday my brains are not working.I have a text file which I need to convert to table. Here is a simple example to demonstrate the problem. Input text file contains street names for cities. City-keyword indicate when the city change.Input text file: Output table:

Hi pretty new to this software/role as BI Developer. I have noticed that when using - @DateTimeParse(@round(@DateTimeNow()),%Y%m%d%H%M%s) In an attribute creator it returns an undefined value of - 19700101000009+00:00. What is the correct way to do this so it returns DateTimeNow.

Hello, After struggling with several transformers, I can't figure out how to simply remove duplicates from 2 identical Excel files with exact same column names, etc ... but with different numbers of rows. First file contains 3130 entries and second one 2926. What I want is to be able to extract the 204 missing lines to check their differences. In my small brain, a simple transformer that checks missing entries between two columns and group them in an inspector should exists but it seems not to be complicated enough ... ;o) Thanks for any help

 I have been able to do this using the HTTP caller. The issue I have is the the URL that I am calling changes slightly each week. The number in the URL increases by one each week. Is there a way I can automate the change in the URL so that it will retrive the up to date document from the link? Thanks in advance for any assistance.

We are needing to migrate fiber data from a typical GIS-based fiber platform into the new Esri Communications Data Management model (uses Esri Utility Network), however, the data structures are completely different when it comes to associations for items like fiber strands and equipment ports.

When I select a string function from the left banner of the the 'Text Editor' window, I notice that the function in the main window will only indicate required attributes to specify. For example, when selecting 'FindString', in the main window the example text '@FindString(<string>,<strToFind>)' is shown. However, if I look at the documentation on the string functions: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/!Transformer_Parameters/StringFunctions.htm,I see that also the following optional param

I am running FME(R) 2019.2.3.2 (20200320 - Build 19825 - WIN64)I am trying to convert a cloud-optimised geotiff into an ecw image (v2)The image has GDA2020 datum, MGA Zone 56 projection, which is EPSG: 7856https://epsg.io/7856 The output ecw does not have the correct values for datum & projection in the header. I can use ERDAS Imagine to read the header valuesThis is the result from FME (as per attached image from_FME.png)Datum EPSG: 1168Projection Name SUTM56EPSG Code 0 To compare, I used ERDAS Imagine to perform the same conversion and these are the header values (as per attached image from_Imagine.png)Datum GDA2020Projection Name Transverse MercatorEPSG Code 7856 I would prefer to use FME as it does bulk translations well. But I need the header information to be correct. How to fix?

It seems to me like I'm looking for a transformer very similar to the ExpressionEvaluator with 'Evaluation Mode' = 'Overwrite existing Attributes', only without the numeric evaluation (that doesn't seemingly 'wrap' the expression in a arithmic editer). I thought about posting an idea about this (e.g. create new transformer or add parameter 'evaluation mode' = (text|arithmetic) to ExpressionEvaluator), but just wanted to check if I'm maybe overlooking existing functionality. Attached is a workspace that illustrates the numeric evaluation possibilities in the ExpressionEvaluator, and an example of how I would like to have the option for a 'text evaluation' possibility to e.g. add '_concat_@CurrentAttribute' to each attribute in the selected group.  

When I use any SQL reader if I limit the attribute in the "User Attribute" tab with the option "Exposed Attributes": FME seems (regarding perf) to use a query like "Select Attrib1, Attrib2 from..." in place of a "Select * from ..." when I use Feature Reader It fetch all column even if I output to generic port and expose only some attribute. I have some Huge binary and text collumn that I dont need and I fetch thru a slow connection. Any Idea ?

Hey community! I need to know if I can export in a python script language my total transfomation of my workflow. Can I do it? And how can I make it?

So, I have a linear dataset of rivers. I have developed a RIVER_ID that serves as a unique ID per river. Saying this, one RIVER_ID usually has more than 1 unique ID depending on how long the river is. I firstly created them grouping by name in the network topology and using the Network_ID as a RIVER_ID. Later, I calculated Strahler order and used that to assign to unnamed rivers. So, what I want to locate are rivers (same RIVER_ID, could be multiple unique features) that touch a different RIVER_ID minimum two times (think about river sleeves). So, I went with Spatial Relator but I am now realising that a Spatial Relator will only give me 1 related candidates if my Requestor is touching the same IDd river at two locations and not two as I was hoping to get. Another thing that pops on my mind is using a snipper to get the first and last vertices of my Requestor feature and find a number of overlaps with other features and generate a list with these overlaps and check if there are two

Hi,I'am working on my first Augmented Reality model in FME. I have data from cables, sewers etcetera. As an example I found the webinar (https://www.safe.com/webinars/data-in-the-real-world-fme-ar-and-fme-data-express/). This webinar comes with some example workspaces. The workspace CoquitlamInfrastructureAR.fmw seems to do a lot like I would like to do. It looks way more complicated than I'd expected. It's even harder to go through cause the data used is missing. There's a feature reader reading shapefiles, bur the shapefiles are not included. There's also a google sheets reader that I can not use.Can someone provide the data? Thank you in advance,Arno

Consider for example the case with a FeatureMerger or a FeatureJoiner. I have always been wondering how the groupBy is executed here. Is this on a single port (e.g. Requestor or Left) or across multiple ports. Especially in combination with the option 'Process when group changes'.  I made a small illustration workspace, with the merging application inspired on 'a hiccup' I came across today where I wanted to accumulate incoming attributes at a 2DGridAccumulator, but there is no default field/option for this (an idea on this was already created, see; https://community.safe.com/s/idea/0874Q000000TlLbQAK/detail).  To see differences in results, I changed the order of the features entering the supplier input port of the FeatureMerger, and for whether features should first route to th

I would like to rename a large dataset of many columns using a lookup file (csv or xlsx) - is this possible? I have explored the ..Mapper transformers, but am unable to get them to work in this way. The only method that appears possible at the moment is through the AttributeRenamer, but am finding this rather tedious entering one by one. The Import facility on this transformer only appears to name Input and Output Attributes with the same names when I use it.Happy to be corrected in my use of this transformer!The column name lookup I have structured in a spreadsheet as below;

Hi All, I have a Child workbench which takes input as SDE FeatureClasses and Creates FGDB. i am passing all feature classes dynamically to the writer (all different types like points, polygons and polyline featureclasses). My SDE Feature Class has Long Attribute(Fields) Names and I required to create FGDB Feature Classes with Short Attribute(Fields) names. I have a web service which gives JSON output of Short Names. For each feature class, i need to connect to web service and get short names, create FGDB feature class with these short names. Could anyone have an idea how can I dynamically update FGDB feature class?

I got some multiband raster images and want to create a workspace which allows the user to choose the bit depht/color depht between Grayscale (8bit), RGB(24bit) and Palette (8bit). I used the RasterInterpretationCoercer but it does not work with the Grayscale, because the input images contains multiple bands. Anynone can give me a hint to make it possible? Thx and best wishes Barry

I tiled a raster image with the RasterTiler and get as result 4 tiles and now I want to name the workspace output file like the output tile numbers. Like this: up left tile= 1 -> Filename_1.TIFup right tile=2 ->Filename_2.TIFbottom left tile=3 -> Filename_3.TIFbottom right tile= 4 -> Filename_4.TIF So I used the stringconcetonator to name the attributes like the tile numbers, but I dont get the desired result what am I doing wrong? Best Wishes Tina

Hello all, I want to create an user parameter to let the workspace user choose between three different picture depht/bit depht: (gray 8, palette 8 and RGB24). I used the RasterInterpretationCoercer, but how do I connect it right with an user parameter? My Result is an userparameter prompt with an list of all possible choices of the RasterInterpretationCoercer (below in the attached picture) But I want just the 3 different possibilities Thank you very much.

When i am trying to read the XML-file "bomen-elburg_short" I get this error: XML Parser error: 'Error in input dataset:'bomen-elburg_short.xml' line:23 column:46 message:prefix 'gml' can not be resolved to namespace URI'Whats going wrong, and how can i solve this?

I have eight lines going into a snipper that are identical with the exception of a distance attribute. I am trying to trim these lines to the length specified in the distance attribute. Two of the lines trim correctly and the other six trim to "0" length and exit as a point. The min and max extents coming in appear to be correct but the min and max extents of the output show the six points being the same. I have reviewed this question from the past: snipper point in exit (https://community.safe.com/s/question/0D54Q000080hdg9SAA) but didn't find my answer there. Here is a snippet of my workspace. 

How do I access a AGOL feature attachment that is a JPEG and save it as a file. The AGOL reader allows me to access the attachments, but the data is in format attribute. How do I write that back out as a JPEG file on my system?

Hello im relatively new to FME and I want to determine the resolution of raster images with the transformer "RasterPropertyExtractor", how can i set this transformer to supply the resolution dynamically? Because I want to use the workspace for different images with different resoulutions.  Thank you and Best wishes Barrylim