Crosstab analysis

KNIME Analytics Platform
1

Hello,

Can anybody share their workflow on crosstab analysis showing row/column totals in one table? Thanks.

Xiaoni

2

Hi there
Depending on what you like to do, the pivot node offers these sums

3

Yes it offers the sum but I wanted to know how to present the data in a table format that shows frequency, column sums and row sums in one output format.

4

for agregating the sums to the table you can do the folling:

  1. Summs of columns:
    linkt the the upper and the lower exit of th epivot node together with the concatenate node

  2. Summs of rows:
    join the output of the concatenade node to the middle output of the pivot node using rowID as key and set on full outher join (to see the totals of the columns…
    07%20AM

1 Like