Icon

Table Pivot without Aggregation

Table pivot without aggregation
Basic pivotingGrouping prices of various products across time (in months)Prices expressed as median (as an example of aggregation method)Group column - MonthPivot column - Product Pivoting without aggregationPrices of each replicate of the product across time (in months)Group column - MonthPivot column - ProductReplicates labelled with (#1), (#2), etc. Useful for general data summary Useful for analysing individual trends of replicates, e.g.regresion analysis for each replicate over time Other applications - concentration response analysis inHTS (replicates of Compound A, Compound B etc.versus concentrations) Example tableCreates pivot table, and summarises the raw data for each column(Row label/Group column - Month)(Column label/Pivot column - Product)Creates pivot table, and creates a list of the raw data for each column(Row label/Group column - Month)(Column label/Pivot column - Product)Splits collection columnStarts column loop for column expansion and renaming(filtered based on type)Extracts column headerTransposes cell for easy flow variable extractionCreates flow variableExtracts column headerTransposes rows into a single columnString manipulation to rename replicatesReplaces the old column headers with new ones Ends loop by appending columnsSeparates the columns containing listsAppends the columns Table Creator Pivoting Pivoting Split CollectionColumn Column ListLoop Start ExtractColumn Header Transpose Table Rowto Variable ExtractColumn Header Transpose String Manipulation Insert ColumnHeader Loop End (ColumnAppend) Column Splitter Column Appender Basic pivotingGrouping prices of various products across time (in months)Prices expressed as median (as an example of aggregation method)Group column - MonthPivot column - Product Pivoting without aggregationPrices of each replicate of the product across time (in months)Group column - MonthPivot column - ProductReplicates labelled with (#1), (#2), etc. Useful for general data summary Useful for analysing individual trends of replicates, e.g.regresion analysis for each replicate over time Other applications - concentration response analysis inHTS (replicates of Compound A, Compound B etc.versus concentrations) Example tableCreates pivot table, and summarises the raw data for each column(Row label/Group column - Month)(Column label/Pivot column - Product)Creates pivot table, and creates a list of the raw data for each column(Row label/Group column - Month)(Column label/Pivot column - Product)Splits collection columnStarts column loop for column expansion and renaming(filtered based on type)Extracts column headerTransposes cell for easy flow variable extractionCreates flow variableExtracts column headerTransposes rows into a single columnString manipulation to rename replicatesReplaces the old column headers with new ones Ends loop by appending columnsSeparates the columns containing listsAppends the columns Table Creator Pivoting Pivoting Split CollectionColumn Column ListLoop Start ExtractColumn Header Transpose Table Rowto Variable ExtractColumn Header Transpose String Manipulation Insert ColumnHeader Loop End (ColumnAppend) Column Splitter Column Appender

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: astl3
Created at: 2021-04-26
On NodePit since: 2021-05-14
Last update: 2024-04-27
Created with KNIME version: v4.3.2
Tags: TableKNIMEPivotAggregationDereplicationLoopColumn loopGroupingOrganizing dataHTSConcentration responseDose responseDyanmicDynamic columns

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

Try NodePit Runner!