Hello, I have a table with 3 records per house. The table includes hundreds of houses. I want to create a new attribute called Type. There are two types only : A and B.
For Type A: two values of attribute a1 per house equal the value of attribute a2 of another record of the same house.
For Type B: two values of attribute a2 per house equal the value of attribute a1 of another record of the same house.
How can I automatically assign the type to each record of any given house? Thx.
