Icon

Combine ExpressionSet Loader

Load dataIn this part of the workflow we load 3 different studies forthe same compound.In the ExpressionSet Loader we need to indicate the typeof assayData (here we use "exprs") Manipulate DataConcatenate nodeHere we combine all different studies together. The "concatenate node" adds thetables together. For column-handling we choose "union", this means that columns that onlyappear in one table will be added to the output-column and will get empty valuesfor the rows that came out of the table without that column.If you choose 'intersection" => only columns that appear in all input tables will beused.Column Filter nodeColumn filter is used to keep only those columns we need for vizualizationJoiner nodeThe joiner node adds both concatenated tables together. These tables havedifferent columns but do have an identifier that is the same. So in contrast withthe "concatenate node" here we don't add rows, but we add columns. The valuesare based on the identifier. Here we chose 'rowId" which is a proxy for patienId.PivotingThis node groups the data together. Based on the ARM (placebo-treated) and theUSUBJID (..) for every unique combination of ARM - USUBJID we use visit ascolumns and Amylase as values. VizualizationRow Splitter nodeThis node is used to split the table in 2. One table with all rows that have"placebo" in the ARM column and one table with "treated" in this column.Color Manager nodeThis node is being used to add color for the scatter plot vizualization. This color isadded for ARM (treated - placebo) in the original (not splitted) table where ARMhas both values.Vizualization Prototype nodeThis node is a component for creating a scatterplot and 2 boxplots. Node 6Node 7Node 8Node 9Node 10Node 33Node 40Node 41 Task Chooser ExpressionSetLoader Task Chooser ExpressionSetLoader Task Chooser ExpressionSetLoader Column Filter Column Filter Concatenate Concatenate Joiner Pivoting Color Manager Row Splitter VisualizationPrototype ExpressionSetLoader Load dataIn this part of the workflow we load 3 different studies forthe same compound.In the ExpressionSet Loader we need to indicate the typeof assayData (here we use "exprs") Manipulate DataConcatenate nodeHere we combine all different studies together. The "concatenate node" adds thetables together. For column-handling we choose "union", this means that columns that onlyappear in one table will be added to the output-column and will get empty valuesfor the rows that came out of the table without that column.If you choose 'intersection" => only columns that appear in all input tables will beused.Column Filter nodeColumn filter is used to keep only those columns we need for vizualizationJoiner nodeThe joiner node adds both concatenated tables together. These tables havedifferent columns but do have an identifier that is the same. So in contrast withthe "concatenate node" here we don't add rows, but we add columns. The valuesare based on the identifier. Here we chose 'rowId" which is a proxy for patienId.PivotingThis node groups the data together. Based on the ARM (placebo-treated) and theUSUBJID (..) for every unique combination of ARM - USUBJID we use visit ascolumns and Amylase as values. VizualizationRow Splitter nodeThis node is used to split the table in 2. One table with all rows that have"placebo" in the ARM column and one table with "treated" in this column.Color Manager nodeThis node is being used to add color for the scatter plot vizualization. This color isadded for ARM (treated - placebo) in the original (not splitted) table where ARMhas both values.Vizualization Prototype nodeThis node is a component for creating a scatterplot and 2 boxplots. Node 6Node 7Node 8Node 9Node 10Node 33Node 40Node 41 Task Chooser ExpressionSetLoader Task Chooser ExpressionSetLoader Task Chooser ExpressionSetLoader Column Filter Column Filter Concatenate Concatenate Joiner Pivoting Color Manager Row Splitter VisualizationPrototype ExpressionSetLoader

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: Echos Bv
Created at: 2022-02-08
On NodePit since: 2022-02-11
Last update: 2024-04-27
Created with KNIME version: v4.5.1

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

Try NodePit Runner!