Hi
I need to extract the distinct attribute values of each field/column. An example is provided below:
Input
Owner Building_Type Building_ Age
Row 1: Steve Office 1970-79
Row 2: Adam Office 1980-89
Row 3: Steve House 2001-5
Output:
Owner Building_Type Building_ Age
Row 1: Steve Office 1970-79
Row 2: Adam House 1980-89
Row 3: NULL NULL 2001-5
Any help will be appreciated.