Transformers

Hi,I have two tables in file geodatabase and both are the same structure.Both tables are having around 140 columns and 4000 rows.In table 1 there are many fields are "null" and "0" and remaining fields are filled with some values.In table 2 filled with some values and also few fields with "null" and "0" valuesIn both table is having "ID" common unique value field available.Condition is.I need to update Table 1 based on below scenarios1. If fields values available in both then no need update2.If table 1 is having "null" and "0" values then update new values if available in table 2.3.if table 1 is having some value and if table 2 is having "null" and "0" then no need to update Thanks in AdvanceVenu

Hi,My workspace try to writer in a Table in ArcSDE, but doens't work.Has a way to get the error message from ArcSDE? Similar we have the ora_error for Oracle.Thanks,Danilo

i have a lot of areas which are exactly the same size but they have certain kind of rotations now i have to create point which is located on the down right corner with an offset of ca. 50 -x and 50 +yproblems: when i solve the polygon into points (PointVertexReplacer) not every point on the right down corner has the same IDs (vertexID)...when i set an offset the points will go other directions because of the different rotations of the areashope someone can help me thereThank you and GreetzCheersFranco

Hi,I tried to optimize an existing workflow by replacing all RasterCellCoercers by their PointCloud equivalent as described in:https://knowledge.safe.com/content/idea/22245/spatial-statistics-on-raster-data.htmlI however noticed that there is a small difference in the way the raster values are returnedExample: My original raster value is equal to 23.835The RasterCellCoercer returns 23.835.The PointCloedCoercer however returns a value of 23.834975...When I round these values to 2 digits I get 23.84 and 23.83, depending on the method that was used to extract the raster values.I think this has something to do with the fact that the data type of the components is changed to 'Real64', as described in the logfile:'PointCloudCoercerFactory: Converting component 'z&

Hello everybody.Is a interesting Quiz - fun for this day :). My score was 70 %https://www.qzzr.com/c/quiz/449444/can-you-guess-what-these-pirate-terms-mean :P

Hi,I have some rough shapes (donuts, polygons) that I am trying to dissolve together. I've tried the donut builder tip here https://knowledge.safe.com/questions/4487/dissolver-failure.html but the dissolving still doesn't work and produces the wrong output  

It is a large data set. If there are no values, I want to send the data to a writer, if there are any values, I want to go to the terminator. My issue is that the data set is large and using a tester or attributeValidator isn't work because values are getting to my writer before validation is complete.

I have my SDE destination schema in a file. But I don't see any parameter for Attribute Name Column Alias. So I'm guessing there's no easy way to assign Attribute name aliases. If I'm wrong, would love to learn how to do this.

Hi Folks, I have successfully done a Cross Join In one InlineQuerier where the contents of a field called Query_Filter - is the WHERE Statement I want to apply in another InlineQuerier. I can get the statement to work fine when I paste it in to the second querier - EG Select * FROM "Detected" WHERE (ChemCode ='7440-38-2' AND Concentration > 160 )However when I Write SELECT * FROM "Detected" WHERE Query_Filter It doesnt work. (Query_Filter just containing the text string above.)Im missing something. Any thoughts ?

Hi folks !I want to read HTTP tables for a bunch of url stored on an attribute of my features. However, a basic authentification is needed to access the page.If I set the attribute containing the URL in the source dataset of the feature reader, I cant set any authentification parameters.Everything is working fine if I manually enter one url, then go to the parameters. (as if I use a Reader)Any clue on how to use this authentification in the FeatureReader ?

Hello,I'm using TopologyBuilder to topology of my network.My data is clear and I want to build topology using start/end points (Nodes). It's working fine for me, but I have a problem with 2 cases (similar case) (from 3000 lines).the tool is creating complexe intersections. So, splitting lines, creating additional lines and additional nodes !!the problem is when two line are almost parallel for a while, please see below an examplebut I don't want that, I want to keep the original lines and create just two nodes for each. this result distorts my network.do you have any idea about this strange behavior ? do you have any solution ?Thank you :)Youssef

I'm seeing something weird on my non-Windows FME's in build 17539: the peak process memory usage that's reported at the end of a logfile is 0... This is on my Mac:And this is on FME Cloud (Linux)A Windows machine with the same FME build does show it correctly.Anybody else notice this?

Hello,  I have one main workbench which in turn executes other three workbenches. I used shutdown Pythin script to execute the other workbenches from main workbench.  I am new to FME server and I need to publish this to FME server so that it can accessed in Java Application. I have few questions on this 1. As which type of service I would be able to publish e.g. Data Download Service, Job Submitter etc. 2. Do I need to publish all four workbenches (main plus three workbenches)  to FME server? 3. What is the best way to publish this as a service. 4. Are there anything I have missed and should consider before publishing as a service.  Thanks.

Here at Safe, we are always trying to improve FME as well as our Knowledge Center articles. It recently came to our attention that we don’t know much about how our users integrate R and FME using the RCaller transformer and the great things they are accomplishing with it!Our questions to you: How do you use the RCaller transformer?Are there any RCaller related articles you would like to see?

Hi Guys,an easy one for you i think.... i have one point X and bout 1500 points Y1,Y2.... how can i produce lines from X to Y1 X to Y2 X to Y3 and so onThxGreets and CheersFranco

I have an attribute [complete] withe the value 1-A. I would like to split that value to attribute [split1] with the value 1 and attribute [split2] with the value AI've tried AttributeSplitter;AttributeTrimmer;AttributeCreator

Has anyone else experienced performance issues with the Point On Line or Point On Area Overlayer? In 2016 I have a workbench that does some overlays of about 700,000 lines with 2500 points and it runs within about 30 min (most is reading in features for other parts of the process). But when I try to run it in either 2017.0 or 2017.1 I get to a point where it says, "Creating spatial index" and it's been at it for hours. I tried upgrading the transformers to the latest version, with no change.Just wondering if anyone has any ideas or has had a similar experience.

I wasn't able to find any schema documentation for the FME Server repository, is there any public details I might have missed? Essentially just trying to query source and targets for each workspace. Was able to query this information for readers and writers but we often use "SQL Creators" and/or "Joiners" to pull in tabular information. Is there a way to access those from the repository database? To list out the connection name would be great or even grab the SQL?Here is what we have so far:SELECT   fme_item.name AS "Workspace",   fme_item.title AS "Workspace Title",   fme_item.username AS "Username",   fme_item.lastpublishdate AS "Publish Date",   fme_dataset.location AS "Data Location",   fme_dataset.format AS "Data Format",   fme_feature_type.name AS "Table/Feature Name",   fme_repositoryinfo.name AS "Repository",   fme_dataset.is_source AS "Is Source"FROM   public.

FME Data Inspector disappeared from machine this morning. Upon investigation, it look like Trend Micro AV has picked it up as a virus. Anyone else had this problem?

What are all the files that specify the FME Server hostname, that can't be accessed from the FME Server Web UI or backend database?

I need to pack all the attributes of DGN file by using AttributejSonPacker but unable to expose the attribute "_packer" how can i unpacked the same?

Ahoy, Matey!Would the "Scuttler" be a good name for a transformer created by an FME "Savvy" on the Talk Like a Pirate day?http://metro.co.uk/2017/09/19/international-talk-like-a-pirate-day-pirate-phrases-to-say-to-ye-crew-mates-6937117/