Transformers

Hi All,I was wondering if anyone from the community can help me. I would like to introduce organization to my workspace. I have been using Excel as a large source to workspace structure. Currently, I would like to continue to use Excel to document attribute field mapping, as naming can vary by client.I am using Import Wizard to import attribute values. I have been successful with it thus far with AttibuteManager. My question is if it is possible for import wizard to import conditional statements to AttributeManager Transformer? If so, what is the format or structure to write a conditional statement using external document like Excel?

I am looking to split some data, which is stored in csv but contains commas.Unfortunately it cannot be read in using a CSV reader due to its complexity and non table / row format.An example line of data might look like this: "This data has , a comma in it", "So does, this one", This one does not,"but this one ,does", This one doesnt, or does this one,"Another comma, comma, comma",No comma, still none, still none I considered doing 4 splits:split 1: "," Split 2: ," Split 3: ", Split 4: , And then join the results back together. Although this would work, I need to retain the order of the data and assign an ascending ID.  EG:1 - This data has , a comma in it2 - So does, this one3 - This one does not4 - but this one ,does5 - This one doesnt So my consideration will

Hello!I would like to make a test on my datas. These are points , that have a _pontID and there is a _MIN, MAX and _MEAN values. I want to filter those points where _pontID = _MIN and _pontID = _MAX_uj and _pontID = _mean_pontssz. The problem is that the query only gives back the right solution with _MIN. Here is the definition:The values are like:Can you help me, what can be wrong?

Hello, here is my problem : I create a buffer from input points data. When the distance between 2 points is small, the buffers overlap. I would like to split the 2 overlapped buffers into 2 parts with the same area. Each polygon retrieve the attribute values of the associated point.I don't find any satsfaying solution. Is there a known issue?

I have an old raster that I have to update in the same internal structure. The old one have one band, the new have 4, that gives a factor 5 on data volume. What I want, What I have:

Hi everyone,  i have a simple workbench that uses the ShortestPathFinder to create paths and i have around 1,000,000 from-to lines to query.Before I run the From-To lines through the workbench I made sure that all line vertices are snapped to the nearest network node, and then within this workbench I snapped them again by checking the 'From-To and Network Snapping' option in the ShortestPathFinder transformer. Somehow, the workbench worked I when i send through a sample of From-To lines (around 100 lines), but failed completely when i send through the whole 1,000,000 From-To lines.   The error is - the source/destination node in the shortest path calculation is not a valide node in the network.Did it failed because I am sending through too mahy queries at once? Is there a way to get around this?ThanksRings  

Hi Guys,i have excel file ,i want to make comparisonasif sum 1 < base A < sum 2 if yes ,so as give me the outputi want to check for every cell in base A is the value between sum1 and sum 2 in the each row or not .as example check the first cell of base A (65452 ) is between sum 1 and sum 2 at first row or not then continue to check 65452,first cell of base A with the second row of sum 1 and sum 2 or not . i want to check for each cell in base A ,if this value between sum1 and sum 2 for each row .after finish checking 65452 so start with 65438 and so on so it will check for each cell with 10 rows i want to do the same also for Base B ,if the value between sum 1 and sum 2 and if yes gives me output and continue check for this cell till the end till i finish with all field cells in base A and base B Thanks in advance

could i ask how to get in inspector only the lines that intersected with polygon ,i tried alot with clipperpolygon as input for clipper and lines input for clippee output from inside ,i got the intersected lines with polygon plus all lines inside the polygon .i want only to have the intersected lines with polygon and delete the rest of lines inside the polygon  how could also give intersected lines specific colour . Thanks alot 

I would like to ask ,I have two excel fileAs input First excel has only two attributes ,Column A is part of Column A in the second excel (exactly 10 Same iD of the second excel ),Column B is new data Second excel has Column A includes 90 Id,Column B,Column C,Column DI want to merge the new data on Column B to second excel and create new attribute Column EBut I found when I do merge ,I lost the data beside 10 ID that i want to merge ,it shows missing data. Could I ask ,how can I do that and keep the Data in excel 2 plus Data in Column B from the first Excel .

I need to transpose some of the attributes (with prefix "INTER"), but keep the other ones not transposed.Original data looks like this:The result should look like this:Except not transposed attributes should have values. Obviously AtributeExploder doesn't do the job in this case. How can it be done?

@garydlesterHi !I'm trying to do an elevation profile of some network lines to be exported in AutoCAD. But I'm not being able to adapt the labels and grid so as to be able to view the profile of each section.Could you please help me.Thank you very much.

I am trying to modify an existing workbench which reads features from an Oracle database using an SQLCreator and writes them to a feature class in a geodatabase. Currently there is a single query in the SQLCreator. I'm trying to add something to the output which requires a temporary table so I now need there to be three queries running in this SQLCreator:Create temp_table;Query to extract features from Oracle DB (and temp_table);Drop temp_table; Is it possible to run a series of queries in SQLCreator? If not is there some other way? The series of queries work fine when run directly against the database but I cannot get it to work in FME. My fallback is to create views in Oracle rather than using a temporary table but I'd rather not do that if I can avoid it. Thanks,Michael

Trying to use the long-awaited 12D Reader but the resulting lists are overwhelming. Basically, there are pairs of attribute names and values scattered across lists of various depth and ideally regular attributes with values could be constructed. The attribution in 12D and the resulting lists are bound to different levels of a 12D model. Some attributes belong to the whole model, some to geometries and some to individual vertices. Hence the extensive lists.Vertex attribution: The best I managed is a sequence of List Exploders to get to the last position of a list and then build the attributes using ListKeyValuePairExtractor - This custom transformer seems to struggle with the long nested lists; works fine with pairs on one

 Hello Guys ,i want to split ths two lines that intersected in point, i have coordinates for each x maximum and x min. and y max. and y min , i know,one of them is xmax and the another should be in this case minimum one also is ymax and another should be ymini used topology builder static to make group network id and it did correctly but this two lines i do not want to be in the same group so i used clipper points as input and lines as clippe but i found it did nothing .bcs i used after that zopology builder static and it consider both of them in the same group and i want to give each one new network id so is it possible , to make topology builder static with condition that create network id for all lines except the when it occurs value of x max equal value of x min ,value of y max equal y min .do we have conditional to write it for topology builder . or could i use clipper to split two

I have a coarse raster where the pixel value indicates the number of points that should be generated within the confines of the pixel.  I have a fine raster (1 to 2 orders of magnitude higher resolution than coarse raster) where the pixel value indicates whether a point can be placed there. For simplicity purposes this can be a binary mask.  I would like to generate points according to these two rasters with the additional criteria of a minimum separation between points.  Thoughts on how to do this in an efficient manner? I'm hoping to avoid the brute force approach of generating a random point, checking the constraints and repeating until the desired number of points is reached.

I have a Maria DB and a JIRA platform, I would like to use the DB to create new issues there through the JIRA API, how can I integrate all of them? I have already made the regular CRUD operations to the JIRA platform through the API using the HTTP Caller, but, how can I properly use the SQL Creator to use that data?

 I have Oracle no spatial as a reader and when i am trying to read the coordinate ,i found the output is null and i have read many articles and i tried many hours but without any success . could someone help me ,how can i fix the problem for Geometry for Oracle non spatial  in inspector the output of oracle ,it looks like points and each point has his coordinate (x,y)  Thanks in advance

We have a FME workbench where CSV input is being translated to Shapefiles. This workbench has manually created mapping of attributes e.g. Nominal_Diameter on input and NOM_DIAM on output.Due to some issues with the old workbench I'm trying to re-create the process. And for that I need the attribute name mapping. But I don't want to do it manually as it will take a considerate amount of time.Is there a way how to extract this information from the workbench? E.g. as a text:feature, original attribute name, new attribute nameThanks, Jan 

I want to create Justify aligned Paragraphs in a docx file. I created a custom Heading with Justify alignment in a seed file and input the text via a MSWordStyler transformer with Content Type: Heading and Heading Level: Heading X. but I can't get the text to display correctly. It always spreads the last line. I even tried to use CR and LF in the Text Editor.The text outputs like this:I would like the text to diplay like this:Transformer setings:  Any ideas on how I should configure this to display correctly?

I would like to use JSONTemplater to build nested text structers making use of the ROOT and SUB TEMPLATES but this are not valid JSON ... its  a Groovy syntax ... Beacause is not a valid JSON format the JSONTemplater gets offended and stops the translation. i cant find a way to skip the JSON validationsI tried disabling validation ,,, but nothing ... any alternatives ?   2020-02-21 17:22:01|   2.1|  0.0|WARN  |JSONTemplater(XMLTemplaterFactory): The following error occurred near line 1, column 11 of the query:2020-02-21 17:22:01|   2.1|  0.0|WARN  |JSONTemplater(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)2020-02-21 17:22:01|   2.1|  0.0|ERROR |JSONTemplater(XMLTemplaterFactory): An error occurred while parsing the ROOT t

I have a point vector shape file that consists of the vertices of a number of lines. The data looks kind of like this: (extremely simplified values, but the same format)Feature NumberVertex NumberxyzLayer00101315Main Cable01121420Main Cable 10345Secondary Cable11478Secondary Cable125710Secondary Cable What I want is to create lines that consist of x, y and z values using the feature number as the grouping attribute, ie. All points that have a matching feature number would create a single line, with the vertices starting from lowest to highest. I have tried using CAD, FME and Excel but have had no success.  Thanks in advance!

Difficult to word this one.  I need to generate a table where attributes are generated dynamically e.g.NameFeb-20Mar-20Apr-20      Where the attributes reflect every month from "now" for a set period e.g. a year. I have created a workbench which generates the month-year as attribute values dynamically and then creating Attribute names from these values. However, I can't seem to find a way of exposing these attributes dynamically so that I can then assign values to them. (Currently I have to export them and then reimport them within the attribute exposer). Is there anyway of doing this in a more streamlined fashion?

 i have many lines with diferent id and also Lines with many segments connected together between two area and i have 5 area with different id and different lines intersected with the same area and another lines intersected with another area and so on .some and i have the coordinate of points x,y that refer to the location of point intersected lines with in area ,i want to get the name of area that intersected with diff. lines ,and which lines intersected with this area and and i want to get also when line intersected not only with one ,may be 2 area so i want to know the id of this line and the name of two area that it intersected with . FME 2018 Does spatial relator the transformer that i want or which transformers should i use,i am new in map and iam new in work on map and i am still reading and learning about transformers

I have a shapefile with an attribute ID that contains 23 objects (polygons).I want to use this shapefile to clip the las files and combine them based on the objects.So I want 23 point clouds. I have an idea on how it works, but want to be sure as this is going to run for a long time. My bench looks like this:In clipper I would turn on group by "ID" and merge the attribute just to name the Las file by the value in ID. In pointcloudcombiner I would turn on group by "ID" will this give me the result I want?