New field with Group by and count

[#1]

Hi to all!

I have to create a new field using information of a table.

More specifically, i have the following table (this is only some columns) and i would like to create the last columns (new field):

Order       |   Place             |  Order Catch   | NEW FIELD

13242      |   Milan             |  blank               |   Milan

13242      |   Torin              |  blank               |   Torin

14324      |   Milan              | blank                |   Milan

91453      |   Other North   |  13242             |   Other North

92432      |   Other North   |  14324             |   Milan

I have two type of order, the first that start with the number 1 and the second that start with number 9 as the table above

So i have to show the place using the order catch but only if I have a single place otherwise leave the content of field place for ex other North.

In that table I have a lot of columns as date, year, products, value and other fields.

I thought about the functions aggr and count but in the script is not possible...

Thank you in advance!

Fabio