Input · Folders and loops

Current item

Sits inside every loop and gives you the item the loop is on right now, such as the current file read as a table. It is added for you and can't be removed.

Also known as: Loop input

How it works

The node follows the loop's items source: on each iteration it emits the current item read as a table, a file read by its extension when the items are files, or the row itself when the items are rows of a table such as a Constant Table. At design time it shows the loop's sample item. Sheet / layer names the worksheet of a workbook or the layer of a multi-layer geo file every iteration reads; blank reads the first and it is ignored for other formats. Read all CSV columns as text turns type sniffing off, so a column types the same way in every file; re-type downstream with Parse or Cast Types.

Inputs and outputs

Settings

{
  allVarchar?: boolean
  sheetOrLayer?: string
}

Example

A loop over a folder of CSV exports where amount is sniffed as a number in one file and as text in another, which breaks a shared Parse rule. Tick Read all CSV columns as text on the Current item and add one Cast Types after it. For a folder of workbooks, set Sheet / layer to Data.

More in Folders and loops

• Directory — Lists the files in a folder, one row per file, instead of reading their rows. Wire it into a loop to process every file in turn.
• S3 Directory — Lists the objects in an S3 location that match a pattern, one row per object, so a loop can process each one.
• DB Directory — Lists the tables in a database connection, one row per table, so a loop can run once per table. You can filter the list by name.
• Sheets — Lists the sheets of an Excel workbook, one row per sheet, so a loop can read each sheet in turn.
• File — Reads the file whose path sits in a column of its input: Parquet, CSV, JSON, Excel or a map file, on disk or in S3. Wire a loop's Current item into it to read a different file each time.