Icon

Importing Multiple Files (ETL)

Unzipping A File And Reading TheUnzipped File Into Workflow Example Of Reading InMultiple Excel Files Reading In Files And Setting Filenames AsColumn/Row To Differentiate Read In One Sheet From AnExcel File Read In One CSV File Looping Through All Sheet Names To ReadThe Content From All Sheets In One ExcelFile Looping On All Excel Files In A Folder, Loop Through All SheetNames In Each Excel File To Read The Content From All Sheets InAll Excel Files Reading In MultipleCSV Files Reading Multiple .ZIP Files AndUsing Filenames As Column/Row Adds .csv Files As Worksheets inAn Excel FileUsing .csv Filename As WorkseetName Importing Files (Multiple Ways)This workflow is designed to demonstrate a number of ways you can read data into KNIME.Given my role as an analyst I generally work with .csv and Excel files so these workflows are built around these kinds of files. As long are you can understand the mechanics of how these work though its easy enough to make changes.Some big things to keep in mind: be mindful of your Variables! As you make changes, remap locations and add/subract nodes the variables may change and subsquently break the workflow. So just check the variable outputs and think about what thatmeans.I have used relative pathing and point to data that is inside of this workflow file. If you are configuring this workflow for your ownuse, the pathing/re-mapping may be a bit funky.Where I could and where it made sense I have annotated nodes to help explain what the heck they are doing. Sometimes itcan be really hard to deconstruct a workflow when its not documented well. I have tried to do that here. Finally, if you've been using KNIME for awhile you know that there are many many ways do things. There are countlessvariations to these depending on the work that you do. I have not provided every variation here.Feel free to reach out with questions!Happy KNIMING! Use This To Read In Excel FilesUse This To Read In CSV FilesCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo Open Excel Reader (XLS) File Reader Example Of Reading InMultiple Excel Files Looping Through All Sheet Names To Read TheContent From All Sheets In One Excel File Looping On All Excel Files In A Folder, Loop Through All Sheet Names InEach Excel File To Read The Content From All Sheets In All Excel Files Reading Multiple .ZIP Files AndUsing Filenames As Column/Row Unzipping A File And Reading TheUnzipped File Into Workflow Reading InMultiple CSV Files Reading In Files And Setting FilenamesAs Column/Row To Differentiate Adds .csv Files AsWorksheets in An Excel File Unzipping A File And Reading TheUnzipped File Into Workflow Example Of Reading InMultiple Excel Files Reading In Files And Setting Filenames AsColumn/Row To Differentiate Read In One Sheet From AnExcel File Read In One CSV File Looping Through All Sheet Names To ReadThe Content From All Sheets In One ExcelFile Looping On All Excel Files In A Folder, Loop Through All SheetNames In Each Excel File To Read The Content From All Sheets InAll Excel Files Reading In MultipleCSV Files Reading Multiple .ZIP Files AndUsing Filenames As Column/Row Adds .csv Files As Worksheets inAn Excel FileUsing .csv Filename As WorkseetName Importing Files (Multiple Ways)This workflow is designed to demonstrate a number of ways you can read data into KNIME.Given my role as an analyst I generally work with .csv and Excel files so these workflows are built around these kinds of files. As long are you can understand the mechanics of how these work though its easy enough to make changes.Some big things to keep in mind: be mindful of your Variables! As you make changes, remap locations and add/subract nodes the variables may change and subsquently break the workflow. So just check the variable outputs and think about what thatmeans.I have used relative pathing and point to data that is inside of this workflow file. If you are configuring this workflow for your ownuse, the pathing/re-mapping may be a bit funky.Where I could and where it made sense I have annotated nodes to help explain what the heck they are doing. Sometimes itcan be really hard to deconstruct a workflow when its not documented well. I have tried to do that here. Finally, if you've been using KNIME for awhile you know that there are many many ways do things. There are countlessvariations to these depending on the work that you do. I have not provided every variation here.Feel free to reach out with questions!Happy KNIMING! Use This To Read In Excel FilesUse This To Read In CSV FilesCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo OpenCTRL+Double ClickTo Open Excel Reader (XLS) File Reader Example Of Reading InMultiple Excel Files Looping Through All Sheet Names To Read TheContent From All Sheets In One Excel File Looping On All Excel Files In A Folder, Loop Through All Sheet Names InEach Excel File To Read The Content From All Sheets In All Excel Files Reading Multiple .ZIP Files AndUsing Filenames As Column/Row Unzipping A File And Reading TheUnzipped File Into Workflow Reading InMultiple CSV Files Reading In Files And Setting FilenamesAs Column/Row To Differentiate Adds .csv Files AsWorksheets in An Excel File

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: wdenham
Created at: 2019-05-07
On NodePit since: 2023-05-30
Last update: 2024-11-21
Created with KNIME version: v4.0.1

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

Try NodePit Runner!