Format table

KNIME Analytics Platform
1

Hi Everyone
I have a little problem, and I need your help.
I have a Excel Datei Like this

Unbenannt1
Unbenannt1771×787 17 KB

the Excel Datei: Neuer Ordner.xlsx (636.2 KB)

And I want Like This
Unbenannt4
The number hot, how often comes the Binnes area in an hour

Thank you very much
Vielen Dank,
ich brauch euren Hilfe

2

Hi @Anass,

take Excel Reader (XLS) and Pivoting node.

Pivoting:

  • Groups -> DateAndTimeValue_string
  • Pivots -> Zykluszeit, Istwert [s] [Binned]
  • Manual Aggregation -> esp. Zykluszeit, Istwert [s]

Best regards
Andrew

7 Likes
3

Thank you very much Andres_Steel :+1:

1 Like
4

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