Validate Excel Files and block flow if errors
Demonstration workflow using my Validate Excel Files component to quickly validate the structure of all Excel Files in a folder.
@takbb Brian Bates 27 September 2024
Nodes
- Rule Engine Variable4 ×
- Boolean Configuration2 ×
- Constant Value Column2 ×
- Excel Reader2 ×
- Java Edit Variable2 ×
- String Configuration2 ×
- CASE Switch Variable (End)1 ×
- CASE Switch Variable (Start)1 ×
- Catch Errors (Data Ports)1 ×
- Column Aggregator1 ×
- Column Filter1 ×
- Create Collection Column1 ×
- Create File/Folder Variables1 ×
- Duplicate Row Filter1 ×
- Empty Table Creator1 ×
- End IF1 ×
- Extract Context Properties1 ×
- GroupBy1 ×
- Java Edit Variable (simple)1 ×
- Java Snippet1 ×
- List Files/Folders1 ×
- Loop End1 ×
- Row Splitter1 ×
- Single Selection Configuration1 ×
- String Manipulation1 ×
- String to Path (Variable)1 ×
- Table Row to Variable1 ×
- Table Row to Variable Loop Start1 ×
- Table Validator (Reference)1 ×
- Try (Variable Ports)1 ×
- Variable to Table Column1 ×
- Variable to Table Row1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Data Generation
- FeatureKNIME Excel Support
- FeatureKNIME Javasnippet
- FeatureKNIME Quick Forms
Links
- No links available