Icon

Financial_​Statement_​Reader

Reads _financial_statements.json files from dataset/*/Financial Statement Data/. Extracts income_statement, balance_sheet, cashflow via JSON Path -> JSON to Table -> Ungroup. Concatenates the 3 branches, derives sector/source_file from path, parses period_end, sets ticker and load_batch_id from flow vars, casts metric_value to Double, filters to 8 columns and appends into stg.stg_financial_statements.

Reads _financial_statements.json files from dataset/*/Financial Statement Data/. Extracts income_statement, balance_sheet, cashflow via JSON Path -> JSON to Table -> Ungroup. Concatenates the 3 branches, derives sector/source_file from path, parses period_end, sets ticker and load_batch_id from flow vars, casts metric_value to Double, filters to 8 columns and appends into stg.stg_financial_statements.

List Files/Folders
Iterate over file list
Table Row to Variable Loop Start
PostgreSQL Connector
Line Reader
Path to String
Conc terms for topics
GroupBy
String Replacer
String to JSON
DB SQL Executor
Expression
JSON Path
Expression
Ungroup
Expression
String to Date&Time
Column Renamer
Combine files
Loop End
DB Writer
Column Filter

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: rl34996
Created at: 2026-07-29
On NodePit since: 2026-08-04
Last update: 2026-08-14
Created with KNIME version: v5.12.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!