Create a VIEW (PIVOT) in Enterprise Geodatase

[WilsonLee]

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
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 Name	Open	Closed	Unknown
Building A	2	1	0
Building B	0	1	1
Building C	0	0	1
Building D	1	0	0

[DanPatterson_Retired]

like this but not exact, but worth a look

Pivot Table—Data Management toolbox | Documentation 

[WilsonLee]

thanks,

but i'm looking for the actual SQL Definition in the "Create New View" Tool , see my screenshot

but thanks anyway

[DanPatterson_Retired]

Sorry, I use python/numpy based solutions

/blogs/dan_patterson/2018/02/12/table-tools-a-set-of-tools-for-working-with-tabular-data 

[JoshuaBixby]

The syntax for creating higher-level aggregation SQL, like PIVOT, tends to be very implementation specific, so it is crucial to share what DBMS is hosting the geodatabase.