# Load file content in memory
##  Load file content in memory
### Description
The Load File Content In Memory transform loads the content of a file in memory.
| Hop Engine | ✓ |
| ---------- | ------------ |
| Spark | ? |
| Flink | ? |
| Dataflow | ? |
### Options
#### File Tab
| Option | Description |
| ------------------------------ | --------------------------------------------------------- |
| Filename is defined in a field | Takes a filename from a field |
| get filename from a field | A field containing the filename |
| File or directory | The file or directory path to be added |
| Add | Adds the file or directory to the selected files |
| Browse | Uses the local file browser to select a path |
| Regular Expression | Allows files to be included based on a regular expression |
| Exclude Regular Expression | Allows files to be excluded based on a regular expression |
| Selected files | The selected files to load into memory |
| Show filename(s) | Previews the selected files |
#### Content Tab
| Option | Description |
| ----------------------------- | -------------------------------------------------- |
| Encoding | The file encoding (UTF, ISO, …) |
| Ignore empty file | Ignores empty files |
| Ignore missing path | Ignores missing paths |
| Limit | Limit the rows loaded from the file |
| Include filename in output? | Allows the filename to be included in the output |
| Filename fieldname | Field containing the filename |
| Rownum in output? | Allows the row number to be included in the output |
| Rownum filename | Field containing the row number |
| Add files to result filesname | Add files to resulting files name |
#### Fields Tab
The fields to load from the file.
| Option | Description |
| ---------- | --------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Name | The name of the imported field. |
| Element | File content or size |
| Type | The data type for this field |
| Format | The format mask |
| Length | The field length |
| Precision | The precision option depends on the field type, but only Number is supported; it returns the number of floating point digits |
| Currency | Symbol used to represent currencies |
| Decimal | A decimal point; this is either a dot or a comma |
| Group | A method of separating units of thousands in numbers of four digits or larger. This is either a dot or a comma. |
| Trim type | Type of trim: none, left, right, both |
| Repeat | Enter ‘Y’ if you want to reuse the value from the last non-empty row when the corresponding value in this row is empty. Enter ‘N’ to leave the row empty. |
| Get fields | Retrieve available fields based on the file contents |
#### Additional output Tab
| Option | Description |
| ----------------------- | ----------------------------------------------------------------------------------------- |
| Short filename field | The field name that contains the filename without path information but with an extension. |
| Extension field | The field name that contains the extension of the filename. |
| Path field | The field name that contains the path in operating system format. |
| Is hidden field | The field name that contains if the file is hidden or not (boolean). |
| Last modification field | The field name that contains the last modification. |
| Uri field | The field name that contains the URI. |
| Root uri field | The field name that contains only the root part of the URI. |
#### Buttons
| Option | Description |
| ------------ | --------------------------------------------- |
| Preview rows | Preview the rows generated by this transform. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.primeur.com/data-shaper-1.21/knowing-the-data-shaper-designer/pipelines/transforms/loadfileinput.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.