Pivot tables

KNIME Analytics Platform
1

hello,
I’m trying to replicate a step that I do in excel as part of a work flow in knime and struggling to get the right results.

Ex:Table 1

cases | numbers| names | towns | salary
001 418-232-3232 - Jack Colorado Springs 45000
…

I want to pivot to count the number of cities and avg of salary as below

Row Label | Count of towns | Avg of salary
Colorado Springs 3 66000
New York 122 77000
Irvine 44 55323

etc

thanks

2

Welcome to the forum @Carl321. This should be doable using the Pivoting node. Can you share what you’ve done so far?

3

Hi @Carl321,
based on the rare information i think you only need the groupby node where you can count and average too.

Your exaple doesn’t show any hint of information which is transposed therefore pivoting probably doesn’t give you the expected result.

BR

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.