Using QGIS, I want to fill a whole column with the same "word".
Is there a faster way or an expression I can use in the field calculator instead of copy/paste?
In some layers I have more than a thousand attributes.
QGIS – How to Set All Values in a Column to Be the Same Using QGIS
expressionfield-calculatorqgis
Related Solutions
The short answer is YES!. That is the power of the calculator. In the attribute table, make your selection (directly on the map, selecting rows in the table or many other different ways). Please make sure that you are in an edit session so that your changes can be undone. If outside an edit session, you have to live with (or fix) your mistakes.
Right click on column name at the top to open the calculator. In the window that pops up, enter your value between quotation marks and select OK. This will automatically fill that value in that column for all the features/rows that are selected.
For more options, learn how to use the python radio button,
Here is a tips and tricks pdf to help.
This resource will help with some automation. and can also be accessed from the right click on the column.
there are some nice links if you hit google
Assuming you don't need a true, database-style auto-incrementing field (which would only work in PostGIS or Spatialite or another db data format), you could simply add a calculation step to your model, calculating an ID column with the expression:
$rownum
… this will give a unique, incremented set of integer values.
Best Answer
With a layer in edit mode and the attribute table opened, choose the field from the left-hand drop-down (it says "abc thi" here), set the value (in the box after the expression editor "E" sign), and hit "update all":
Note that string values have to be in single quotes
'in the expression box.Switch edits off and save changes.