Proyecto Ciencia de Datos 2023
There has been no title set for this workflow's metadata.
Remove Non-Business Days
The following is an example of how to remove days that aren't working days. In this workflow we first remove the dates which are on the last two days of the week and then use an API (https://date.nager.at/) to fetch the public holidays of the selected country and filter those out as well. Not all countries are contained, since the public holiday API being used is not complete.
Nodes
- DB Table Selector (Labs)61 ×
- DB Reader (Labs)35 ×
- DB Joiner (Labs)28 ×
- Column Filter25 ×
- String Manipulation24 ×
- DB Table Creator21 ×
- DB Writer21 ×
- Column Renamer19 ×
- RowID19 ×
- Joiner16 ×
- Column Resorter11 ×
- Constant Value Column9 ×
- Date&Time Difference8 ×
- String Replacer7 ×
- CSV Reader5 ×
- Column Expressions5 ×
- Concatenate5 ×
- Row Filter5 ×
- Variable Creator5 ×
- Variable to Table Column5 ×
- String to Date&Time3 ×
- Add Empty Rows2 ×
- Binner (Dictionary)2 ×
- Duplicate Row Filter2 ×
- Date&Time Part Extractor2 ×
- GroupBy2 ×
- Missing Value2 ×
- PostgreSQL Connector (Labs)2 ×
- Table Creator2 ×
- Table Row to Variable2 ×
- Cell Splitter1 ×
- Column Appender1 ×
- Create Date&Time Range1 ×
- GET Request1 ×
- Group Loop Start1 ×
- JSON Path1 ×
- JSON to Table1 ×
- Line Reader1 ×
- Loop End1 ×
- Single Selection Configuration1 ×
- String to JSON1 ×
- Ungroup1 ×
- Unpivoting1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Column Expressions (Labs)
- FeatureKNIME Database
- FeatureKNIME Javasnippet
- FeatureKNIME JSON-Processing
- Show all 7 modules
Links
- No links available