Icon

02-01 - Loops

There ARE MANY different loops available:

The most common are:
- group loop
- table row to variable loop
- chunk loop
- recursive loops
- column list loop start

There SOME loop ends available:

Loop End -- concatenate tables from each iteration

loop end (variable)
loop end (column append)
recursive loop end -> data from last input port is send back to recursive loop start

Iterative Zeilenweise Berechnung
Addiere den Wert von ersten Zeile zur den anderen

oben: Daten die in den Output gehen sollen (so wie Standard-Loop-Ends)

unten: Daten die in die nächste Iteration gehen sollen

Read all Excel-Sheets from a File

Read all Files from a Folder

Read all Excel-Files from a folder, save csv files seperately

Loop End - Nodes can have multiple output!
Open branches are executed as well!

Recursive Loop Start
Loop End
Zeilenweisen = 1
Chunk Loop Start
Loops all INTColumnsALL ROWS ARE PASSED
Column List Loop Start
Group = education
Group Loop Start
Example Data Reader
List Files/Folders
If Excel Files are equally, just read in folder once
Excel Reader
Math Formula
Table Row to Variable
Some Silly Math
Excel Reader
Read Excel Sheet Names
Table Row to Variable Loop Start
Loop End
Oben: RohdatenUnten: Aggregiert
Loop End
Row Filter
Variable Loop End
Excel Reader
GroupBy
Loop End
CSV Writer
Constant Value Column Appender
SQLite Connector
Loop End (Column Append)
Example Data Reader
Create File/Folder Variables
DB Writer
Batchweisen > 1
Chunk Loop Start
Rename back to Current Column
Column Renamer
Recursive Loop End
Loop End
Column Filter
Table Row to Variable Loop Start
Rename Current Columnto generic name
Column Renamer
PrepareFileName
Example Data Reader
Batchweise mit Überlapp
Window Loop Start
Table Creator
Loop End
Do Some Stuff
Table Creator
oben erste Zeileunten Rest
Row Splitter

Nodes

Extensions

Links