Icon

sas7bdatToDatabaseExample

List sas7bdatfiles in folderLoop over filesEstablish DBconnectionCreate tablestructureExtract file name touse as table nameWrite totableCollect loopiterationsvarious manipulationsgo hereSAS7BDAT Reader List Files Table Row ToVariable Loop Start H2 Connector DB Table Creator URL to FilePath (Variable) DB Writer Variable Loop End Data Cleanup List sas7bdatfiles in folderLoop over filesEstablish DBconnectionCreate tablestructureExtract file name touse as table nameWrite totableCollect loopiterationsvarious manipulationsgo hereSAS7BDAT Reader List Files Table Row ToVariable Loop Start H2 Connector DB Table Creator URL to FilePath (Variable) DB Writer Variable Loop End Data Cleanup

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: ScottFincher
Created at: 2020-03-09
On NodePit since: 2022-02-06
Last update: 2024-04-23
Created with KNIME version: v4.1.2

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

Try NodePit Runner!