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.
concatenate( "Building" || '-' || "Floor" || '-' || "Area2" || '-' || "Room Numbe" )
Basically the calculator is concatenating all records across the above fields until reaching the character limit. I'm not sure how to only concatenate by record.