Icon

Tabulating rows into columns with lag calculation

Tabulating rows into columns

Example of using pivoting node to turn row-based data into tabulated column data

Sample Datacontaining 2 patientstabulate the rowsrename the columnswith _ instead of +Lag the rank columnjoin each topreviousso calc can be performedbetween 2 rowsdo calculationtabulate the rowsrename the columnswith _ instead of +Node 10Extract Data Tablefrom Delimited Text Pivoting Column Rename(Regex) Lag Column Joiner Math Formula Pivoting Column Rename(Regex) Column Filter Sample Datacontaining 2 patientstabulate the rowsrename the columnswith _ instead of +Lag the rank columnjoin each topreviousso calc can be performedbetween 2 rowsdo calculationtabulate the rowsrename the columnswith _ instead of +Node 10Extract Data Tablefrom Delimited Text Pivoting Column Rename(Regex) Lag Column Joiner Math Formula Pivoting Column Rename(Regex) Column Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: bbate
Created at: 2023-07-27
On NodePit since: 2023-08-04
Last update: 2024-04-27
Created with KNIME version: v4.7.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!