Summarizing the data like Excel pivot

SahadhKuruniyan

Hi Team,

I have data like below. 

Team	Product
A	X
B	X
C	Y
D	Z
D	Z
C	Z
A	Y
B	Y

I am looking for a tool which help me summarize the data like below:

Row Labels	X	Y	Z
A	1	1	0
B	1	1	0
C	0	1	1
D	0	0	2

Gawa

Hi, @SahadhKuruniyan 

This is super easy by using Cross Tab tool. Tips is that, before Cross Tab, adding one column with value=1, and specify this field as Value column of Cross Tab configuration.

After that, non exist cell will be "Null", so replace them with 0 by Data Cleansing Tool.

Refer to attached workflow for more detail.

Summarizing the data like Excel pivot_gawa.yxmd