Icon

2021_​03_​29_​Grouped_​Excel_​Data_​Processing

Grouped Excel Data Processing
Grouped Excel Data ProcessingThis workflow demonstrates how to process Excel data with multiple "tables" on a single sheet.Forum link: https://forum.knime.com/t/use-loop-till-condition-or-any-other-better-way/31707 Input data(Relative path to data folder)Process each groupCollect resultsAll values in one columnNode 55 Excel Reader Group Loop Start Loop End Unpivoting Prepare datafor Grouping Prepare groupeddata for Unpivoting Grouped Excel Data ProcessingThis workflow demonstrates how to process Excel data with multiple "tables" on a single sheet.Forum link: https://forum.knime.com/t/use-loop-till-condition-or-any-other-better-way/31707 Input data(Relative path to data folder)Process each groupCollect resultsAll values in one columnNode 55 Excel Reader Group Loop Start Loop End Unpivoting Prepare datafor Grouping Prepare groupeddata for Unpivoting

Nodes

Extensions

Links