Not sure if I'm missing something very basic or not, but I have 6 or 7 shapefile vector layers in a dozen or so models that I need to update a single field with a rather simple formula. I could spend the time to simply edit each layer and update the field, but I was hoping to use the processing modeler to take advantage of batch processing. My trouble is that I'm not understanding how to use the modeler to update existing layers - I've used it several times to create a new layer, but not update any existing ones. I assume I'm just missing a piece of the puzzle?...
An example is that I have a field called "MNCPL_ID" which I want to update with: lpad( "STREETID" ,4,0) || lpad( "SEGMNTID" ,3,0) || lpad( @row_number,3,0)
- easily done layer by layer with the field calculator, but how can I automate the process?
(Bonus points if you have a suggestion to make the last 3 numbers sequential for each "STREETID" instead of using @row_number)
*Not familiar with python scripts / still learning.