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

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
GET USDA API Data
GET Request
Insert toTERMINALMARKET table
DB Row Inserter
User & Report Title Var
Variable Creator
Today's Date String
Java Edit Variable
Oracle Connector
Convert Java VarTo Table Row
Variable to Table Row
Change String Datesto Date Obj
String to Date&Time
Calc Days to Last Saturday
Math Formula
Uses dates to create a dynamic URL
Variable Expression
Adding in Dynamic Vars
Variable to Table Column
Java is StrConvert to Date
String to Date&Time
Yesterday
Date Shifter
Url Date Vars
Table Row to Variable
Replace NA with null
Date Shifter
Delete past 14 days
DB SQL Executor
Date&Time to String
DB Query Reader
Split Location col for reporting_city Oracle col
Cell Splitter
Add import_export columnif origin is in the US
Rule Engine
Unwrap JSON
JSON Path
Replace price nulls with 0s. Oracle can't take nulls in number cols.
Missing Value
Transform rowlists to table
Ungroup
Rename all colsfor insertion
Column Renamer
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-09-20
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!