Filename/Wildcard

There are two ways to access the files present on the server.

Star – Using '{}{*}' you can access all the files. For example, using *.xlsx, you can match all the datasets with this extension. Hence, all of these datasets will be verified.
Question mark – Using a single '?' you can access the dataset files with one different character. For example, IRIS_?.xlsx will enable you to access files like IRIS_2.xlsx, IRIS_3.xlsx, and so on.

(info)
Note:

All the files are expected to have the same number of data columns. However, if this is not the case, the missing columns in the files are appended with NaN values.

Traverse Subdirectory

This feature enables you to check for available files in the underlying subdirectories in addition to the selected root folder. It traverses subdirectories up to the n^th level.

Delimiter

In the text files, Delimiters are used to separate the different independent regions in the data streams.
For example, ';' acts as a delimiter in a series of semicolon-separated values.
If no delimiter is passed, these regions will be merged as one.

Notes:

In the case of text files, you cannot use *.txt to access all the text files if the files on the FTP server are not separated by the same Delimiter
You can use *.txt only in a situation where all the files present on the FTP server are separated by the same delimiter.
For JSON files, the wildcard option is not provided. Instead, you can enter the entire file URL to access the respective data files from the FTP server.
This makes accessing and selecting files from the server an easy task for the user.
You can also upload a single file instead of choosing multiple different files. You can do this for all the file types; Excel, JSON, CSV, and .txt.
The filename for all the files must be unique.

Your Rating:

Table of Contents