AnsweredAssumed Answered

Create a VIEW (PIVOT) in Enterprise Geodatase

Question asked by wilsonl on Mar 28, 2020
Latest reply on Mar 29, 2020 by bixb0012

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 NameStatus
Building A
Open
Building A
Open
Building A
Closed
Building B
Closed
Building B
Unknown
Building C
Unknown
Building D
Open

 

my goal is to create a VIEW (pivot) below based on the TABLE above

 

Building NameOpenClosedUnknown
Building A
210
Building B
011
Building C
001
Building D
100

Attachments

Outcomes