You can use an attributecreator with adjacent attribute handling to create a new attribute on each feature that lists the car park. So check if first column begins with the word Car Park, if it does create an attribute called Car Park with that value, if it doesn't use the value of Car Park from the previous feature to set the value of Car Park

Hi

Thanks for this. Unfortunately the actual data does not contain the word car park but i have got the data just to have the name of the car park in a column or an empty string.

However, I am failing on attribute creator bit. Ive set up the adjacent feature (which is an amazing feature I did not know about) and the conditional statement but it will not let me use the value of this new attribute in the calculation - it just highlights it red. Any clues to what I am doing wrong?

Thanks

The easiest way to remove this is to add an additional AttributeCreator before the one that does hte adjacent feature handling which creates the CarPark attribute. I'm pretty sure it still works, even when it's highlighted red like that, but it's annoying so I normally add in the extra AttributeCreator

It doesn't look like your conditional statement is set up quite right at hte moment, as it looks like you're using the empty location attribute to set the value

Hi

I have added the extra AttributeCreator in (and corrected the Location statement to NOT empty!) and it works perfectly. Thank you so much for your help.