Icon

LAB 2 Part 5

Task 1: Create a Tag Table1. Unpivot the Excel table with the XLS Control Table Generatornode. Write column header to first row.2. Replace the values in the Value column with the followingtags:- "header" in the first row- "freeze" in the second row- "risk" in all rows where the travel risk category is 43. Create a tag table with the XLS Control Table Generator node Task 2: Format an Excel Sheet1. Make the header font bold2. Freeze the header row3. Change the cell background to red where the risk category is 44. Change the column widths to 145. Export and inspect the formatted Excel table meteorite_labdings.csvfreeze the header rowbold headerredwhere fall = fellautosizecolumn width CSV Reader XLS ControlTable Generator XLS ControlTable Generator XLS SheetProperties XLS Font Formatter XLS BackgroundColorizer XLS Formatter(apply) Rule Engine XLS Row andColumn Sizer Task 1: Create a Tag Table1. Unpivot the Excel table with the XLS Control Table Generatornode. Write column header to first row.2. Replace the values in the Value column with the followingtags:- "header" in the first row- "freeze" in the second row- "risk" in all rows where the travel risk category is 43. Create a tag table with the XLS Control Table Generator node Task 2: Format an Excel Sheet1. Make the header font bold2. Freeze the header row3. Change the cell background to red where the risk category is 44. Change the column widths to 145. Export and inspect the formatted Excel table meteorite_labdings.csvfreeze the header rowbold headerredwhere fall = fellautosizecolumn width CSV Reader XLS ControlTable Generator XLS ControlTable Generator XLS SheetProperties XLS Font Formatter XLS BackgroundColorizer XLS Formatter(apply) Rule Engine XLS Row andColumn Sizer

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: lisah
Created at: 2023-02-11
On NodePit since: 2023-02-11
Last update: 2024-11-14
Created with KNIME version: v4.7.0

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

Try NodePit Runner!