Icon

1.ReadData - solution

Data Blending1. Read the following three data files with KNIME nodes (Drag and drop the files into theworkspace)BRT_CHF.xlsxgpb.csvJPY_CNY.table2. Afterwards join all of them into a single datatable on the TimePeriod3. Visualize the joined data with the Data Explorer node. Investigate other nodes in the visualisationcategory to understand the data.Experts: 4a) Also read the USD.xml file, convert it into a table and join with the rest.4b) Preprocess the file for predictions using the Lag Column node for the GBP or others. 1 2 3 Pricing RangeControl ChartNode 155Node 156Node 157Node 158Node 159Node 160Node 161Node 162Node 163Node 164Node 165Node 166Node 167Node 169Node 170Node 171Node 172 GenericJavaScript View Excel Reader (XLS)(deprecated) File Reader Table Reader Joiner Joiner Data Explorer XML Reader Column Rename JSON to Table XML To JSON XPath Joiner Lag Column preprocessing Linear Correlation(deprecated) Column AutoType Cast Rank Correlation(deprecated) Data Blending1. Read the following three data files with KNIME nodes (Drag and drop the files into theworkspace)BRT_CHF.xlsxgpb.csvJPY_CNY.table2. Afterwards join all of them into a single datatable on the TimePeriod3. Visualize the joined data with the Data Explorer node. Investigate other nodes in the visualisationcategory to understand the data.Experts: 4a) Also read the USD.xml file, convert it into a table and join with the rest.4b) Preprocess the file for predictions using the Lag Column node for the GBP or others. 1 2 3 Pricing RangeControl ChartNode 155Node 156Node 157Node 158Node 159Node 160Node 161Node 162Node 163Node 164Node 165Node 166Node 167Node 169Node 170Node 171Node 172 GenericJavaScript View Excel Reader (XLS)(deprecated) File Reader Table Reader Joiner Joiner Data Explorer XML Reader Column Rename JSON to Table XML To JSON XPath Joiner Lag Column preprocessing Linear Correlation(deprecated) Column AutoType Cast Rank Correlation(deprecated)

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: iris.adae
Created at: 2018-08-31
On NodePit since: 2021-02-15
Last update: 2024-04-18
Created with KNIME version: v4.3.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!