Questions tagged [pivot-table]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
8 views

How to fix blank “input field” column in pivot table?

I need to us the pivot too, so the GM_Naam field are rows and the BG2015 fields are separate columns containing the Area_Ha values. But when I look at the resulting table, the GM_Naam field is ...
1
vote
1answer
24 views

pivot-table and group geometries

Postgresql11 - postgis2.4 Here is a table mytbl with points and an attribute var : geom | var pt a pt b pt1 a pt1 a pt1 b pt2 c ... I want to "rotate" the table like this : ...
1
vote
0answers
64 views

Creating virtual layer or view table from original table using pivot table on QGIS?

I have a table and I need to produce a virtual layer with pivot or crosstable command. Is it possible on QGIS 3.6 or 3.8? My original sql is: select cd_setor, Name, Path_relativo from Fotos order ...
2
votes
1answer
109 views

Flattening multiple fields using Pivot Table in ArcPy? [closed]

I'm trying to flatten a table, but I want to keep/relate certain fields tied to each other. For context, I ran a Generate Near Table to try to find the traffic volumes near intersections. I am trying ...
5
votes
0answers
380 views

Taking ArcGIS feature class to pandas pivot table? [closed]

I'm new to pandas and am trying to create a pivot table based off of two fields - DIVISION and MATERIAL. I'd like to count each occurances of each value. Rows would be DIVISION and columns would be ...
4
votes
1answer
56 views

Labelling Max coverage by Area

I'm struggling to find a quick way to identify and label an area by the maximum coverage of an overlapping polygon. Has anyone done a process like this lately? I'm currently playing with the Pivot ...
3
votes
1answer
211 views

Crosstable two fields of pointfile using ArcMap?

I'd like to produce a simple crosstabulation from two fields of a point feature class. These fields contain land use class information which I'd like to compare. One option is to export a dbf and do ...