CODEWITHSUNDEEP
pivotdolphindb
Summer.H
Summer.H

Reputation: 99

DolphinDB pivot table

I have a table something looking like this:

id CompanyName ProductID productName
-- ----------- --------- -----------
1  c1          1         p1         
2  c1          2         p2         
3  c2          2         p2         
4  c2          3         p3         
5  c3          3         p3         
6  c4          3         p3         
7  c5          4         p4         
8  c6          4         p4         
9  c6          5         p5

Is it possible to run a DolphinDB query to get output like this:

companyName p1  p2  p3  p4  p5
------------------------------
c1          1   1   0   0   0
c2          0   1   1   0   0
c3          0   0   1   0   0
c4          0   0   1   0   0
c5          0   0   0   1   0
c6          0   0   0   1   1

The value in the above table is the number of each product in each company.I get it by the query:

select count(*) from t group by companyName,productName

Upvotes: 0

Views: 38

Answers (1)

xxq1024
xxq1024

Reputation: 11

t1=select count(ProductID) from t pivot by CompanyName, productName
nullFill!(t1,0)

Upvotes: 0

Related Questions