Hi,
I'm new to sql/creating a pivot table as a view in Geodatabase.
I'm looking for the SQL query for the "Create New View" tool (see attached screenshot)
I tried to google many samples but it didn't work out. While I'm still googling, i thought i could ask you guys for help.
My goal is to create a VIEW (PIVOT) based on an existing table in the Geodatabase:
any direction, inputs, sample are appreciated!!!
million thanks!!
Existing table in Geodatabase:
Building Name | Status |
---|
| |
| |
| |
| |
| |
| Unknown |
| |
my goal is to create a VIEW (pivot) below based on the TABLE above
Building Name | Open | Closed | Unknown |
---|
| 2 | 1 | 0 |
| 0 | 1 | 1 |
| 0 | 0 | 1 |
| 1 | 0 | 0 |