Icon

usda_​to_​oracledb

Retrieving data and cleaning

Creating dates and variables associated with them for USDA API URL

Adding/deriving new columns for database to match the MARKETTYPES table

Creating Date and User vars for column

Connect to Famous Oracle DB

Workflow End

Retrieving data and cleaning

Creating dates and variables associated with them for Excel data insertion

Adding/deriving new columns for database to match the MARKETTYPES table

Creating Date and User vars for column

Connect to Famous Oracle DB

Workflow End

Instead of rolling dates, get past two week blocks from Sunday 2 weeks ago to last Saturday

Get Day Number
Date&Time Part Extractor
Date Shifter
User & Report Title Var
Variable Creator
Concatenate
Convert Java VarTo Table Row
Variable to Table Row
Calc Days to Last Saturday
Math Formula
Adding in Dynamic Vars
Variable to Table Column
Java is StrConvert to Date
String to Date&Time
Filter to LA
Row Filter
Yesterday
Date Shifter
Date Shifter
Delete past 14 days
DB SQL Executor
Connect to Oracle DB
Oracle Connector (deprecated)
7 Days Ago
Date Shifter
DB Query Reader
Split Location col for reporting_city Oracle col
Cell Splitter
Add import_export columnif origin is in the US
Rule Engine
Convert Java VarTo Table Row
Variable to Table Row
Java is StrConvert to Date
String to Date&Time
Replace price nulls with 0s. Oracle can't take nulls in number cols.
Missing Value
Yesterday
Date Shifter
15 Days Ago
Date Shifter
DB SQL Executor
Rename all colsfor insertion
Column Renamer
DB Query Reader
Replace price nulls with 0s. Oracle can't take nulls in number cols.
Missing Value
Rename all colsfor insertion
Column Renamer
GET USDA API Data
GET Request
Today's Date String
Java Edit Variable
Insert to TERMINALMARKET table
DB Insert (deprecated)
Excel Reader
Change String Datesto Date Obj
String to Date&Time
String to Date&Time
Add import_export columnif origin is in the US
Rule Engine
Uses dates to create a dynamic URL
Variable Expression
Split Location col for reporting_city Oracle col
Cell Splitter
Table View
Url Date Vars
Table Row to Variable
Url Date Vars
Table Row to Variable
Replace NA with null
Adding in Dynamic Vars
Variable to Table Column
Replace NA with null
Date&Time to String
Connect to Oracle DB
Oracle Connector (deprecated)
Date&Time to String
Change String Datesto Date Obj
String to Date&Time
Insert to TERMINALMARKET table
DB Insert (deprecated)
Unwrap JSON
JSON Path
Today's Date String
Java Edit Variable
Transform rowlists to table
Ungroup
User & Report Title Var
Variable Creator
Table View
14 Days Ago
Date Shifter
GroupBy
Remove GET Headers
Column Filter
Calc Days to Two Weeks Ago Sunday
Math Formula

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: ashiroma
Created at: 2025-09-24
On NodePit since: 2026-08-08
Last update: 2026-08-13
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!