Questions tagged [concatenation]

In formal language theory and computer programming, string concatenation is the operation of joining character strings end-to-end. For example, the concatenation of "snow" and "ball" is "snowball". In some but not all formalisations of concatenation theory, also called string theory, string concatenation is a primitive notion.

Filter by
Sorted by
Tagged with
2
votes
1answer
25 views

StopIteration: iteration not started

I'm trying to update a given field in this case the last one of the table by concatenating all values in the row excepting null values or '' values. So far when execute the code until line: print (...
2
votes
1answer
28 views

Concatenating fields into a new field-QGIS

I'm not sure what I'm missing here. I'm trying to use the field calculator to concatenate multiple fields into one new. All fields are identified as strings. My expression: concatenate( "Building" ...
0
votes
0answers
16 views

Creating list of wetlands with concatenation of unique ids

I am trying to create a table of wetland types per road segment with a field containing concatenation of unique IDs of each wetland type. The source table looks like this: I would like a result that ...
3
votes
1answer
478 views

Merging a geodataframe and pandas dataframe based on a column

I have a simple geopandas dataframe that includes geometry and a column called 'MUKEY': merged_spatial_df.head() I want to merge it to a tabular (.csv) pandas dataframe (which also has a column ...
3
votes
1answer
113 views

Get Attributes from 1:n relation in QGIS as Expression to use in Atlas

I need to set up way signs for something like a "hiking-GIS". In the first step I made a network analysis (using QNEAT3) to find the distance from the signs ("Way Signs") to the available destinations ...
1
vote
1answer
346 views

Simple Field Calculation With No Results in ArcGIS Pro?

I have a grid in ArcGIS Pro that I've named the X and Y axis (in separate columns) and am now trying to do a field calculation on the total grid name (I've tried using both single and double quotes. I'...
4
votes
1answer
223 views

Layout expression for getting all features of layer within the current map view in QGIS 3?

In a map layout template, I want to insert an expression which gets all feature's names of a certain layer, which are contained in the current layout's view/extent. Is there a way to get an aggregate ...
2
votes
1answer
125 views

Add column in QGIS

Is it possible to add a column in the attribute table in QGIS that is a concatenation of two other columns? For example I have a column "Genus" and a column "Species" and I would like to create a ...
3
votes
3answers
2k views

Concatenating strings from two fields using Python in ArcMap Field Calculator?

I'm new to Python scripting and I don't understand what is wrong with this code. I want to concatenate the string values from GRID1MIL and GRID100K. I've created a text column MGRS to begin with. I ...
15
votes
5answers
23k views

Concatenating fields in field calculator of QGIS?

Is there a way to concatenate fields in field calculator of QGIS? (e.g. hectares + ' ha')
3
votes
2answers
361 views

Concatenate attributes ignoring NULL/missing values with FME

I've got a table with different attributes (named "source:geommetry", "source:name", "source:power"...) I'd like to concatenate to one attribute named "source_all" using FME Desktop. A blank space is ...
3
votes
1answer
208 views

QGIS 2.18 label by expression concatenate field strings

For a building layer I have an attribute table with several fields for the building type where data was entered with a manually created form using checkboxes. Example: Production: 1 = (yes), 0 = (no) ...
1
vote
3answers
420 views

Concatenating two columns in ArcGIS 10.2.1: “no records within table”?

I am trying to merge two text columns (consisting of 2 digit and 3 digit numbers respectively) into one in ArcGIS 10.2.1 desktop version, but unable to do so. I have added a new field and kept it as ...
0
votes
1answer
96 views

Concatenate five fields where some may be NULL

I have a trench containing five types of ducts. I have created fields the trenches: Type1, Type2, Type3, ... The values in each field are the numbers of each type of duct that the trench contains. ...
1
vote
1answer
64 views

Syntax error when using concat function

I created a field to display the whole route of several photos in a point layer in order to be able to visualize them on the map. I try to do so by using this expression: concat('C:\Users\DIDAC\...
1
vote
0answers
35 views

I want to combine or merge rasters

I am combining many rasters using a "barcode" that describes attributes for each cell. Combine works on integer values: I combine multiple layers using "combine" tool, then create the bar code by ...
2
votes
4answers
1k views

Concatenating address fields with possible blank or null values in fields using Python parser?

The following Python code is what I have already tried in field calculator of ArcMap 10.5.1: Pre-Logic Script Code: def ConcatAddr(!JOIN_KEY!) val = "" if !Address! <> val ...
2
votes
2answers
380 views

Concatenate geospatial pdfs

I am looking for a simple way to concatenate one geospatial pdf (with multiple layers in a single image) and regular pdf. I have tried tools such as pdfunite, pdftk and pdfconcat, without success. The ...
1
vote
1answer
57 views

Copying specific folder into subfolders with ArcPy?

I'm working on Arcgis 10.5 and I am trying to achieve this: On my script, I want to make folders and subfolder, and also I want to copy one specific folder into several subfolders at the same time. ...
1
vote
1answer
258 views

Concatenate Label Values Fails to Calculate Aggregate

I'm trying to do what seems like a very simple operation (It's SUPER easy in ArcMap...). I'm kind of a novice with QGIS, so it's probably something really simple that I'm doing incorrectly. The ...
2
votes
1answer
1k views

Concatenating string with space

I am adding a number of strings together to create a linestring but as such I need spaces between the initial XY values and the end XY values, plus a comma in between the two halves. Should result in ...
4
votes
2answers
586 views

Concatenating two fields (type double) into single field?

In ArcGIS 10.3 using the field calculator, I'm trying to concatenate a census tract field (double) with a census block field (double) into a single field that has the two values separated by a decimal ...
0
votes
1answer
96 views

Cannot define output with Concatenated path

I am working on a series of geoprocessing tasks and trying to define the output through the concatenation of folders, a geodatabase, and finally a raster dataset. Each way I try it I receive an error ...
1
vote
1answer
173 views

Regrouping concat labels with overlapping intersecting geometries in QGIS

All the fields i want to show on the map are in the same layer. All the labels have to be showed on the map. But the concentration is high. So i would like to concat the labels when geometries are ...
1
vote
1answer
2k views

How to concatenate string and noneType object

My issue is: I can't concatenate string and noneType object. Some attribute values are empty. It follows that label isn't displayed. What is the solution? def FindLabel ( [CONTENU], [...
0
votes
1answer
150 views

Using cursor to populate a new field by concatenating existing fields

I have a question for a current assignment that requires me to write a script that will add a new field to a feature class and then use a cursor to populate the new field by concatenating five other ...
3
votes
1answer
28 views

Find unique ZIP codes and add to field

I have multiple values in a table with the same CODE(Name) and each one has a ZIP. How to find all of the unique ZIP codes and add them to a field. Here is an example of the result I am looking for: ...
0
votes
0answers
127 views

Spatial join with concatenation of results

I've two polygon layers which I would make a spatial join. The objective is to transport a specific code from layer A (Municipality) to layer B (Issues) using like a concatenate function, in this way ...
1
vote
0answers
42 views

QGIS: Join by Location: Option to retain all attributes of spatially related objects of my join layer [duplicate]

I am facing the problem that I want to join the attributes from one specific column of ALL intersecting features from my join layer to my target layer in case of an intersection (1:n relationship) ...
5
votes
5answers
9k views

How to combine text and integers in a string field?

I have field with numbers in it (field type: double, number format: numeric) and I need to create a new field and put text in front of the numbers. I know that I need to add a new string field, but ...