<< Click to Display Table of Contents >> Navigation: Reference > Meta Information |
You can add meta information to input data using the Meta info field in the Right pane when you select an input item.
Set it to At start, At end or Every row, depending on where you want the meta information to appear. Then click on the ... button to edit which information you wish to show. The following placeholders are substituted by their actual values at the time of input.
Meta Information |
Description |
Example |
---|---|---|
$(ComputerName) |
The name of the computer. |
MyComputer |
$(CurrentDate) |
The current date, in ISO format. |
2020-08-18 |
$(CurrentDateTime) |
The current datetime, in ISO format. |
2020-08-18T18:00:00 |
$(DataColumns) |
The number of columns in the dataset (not including meta data). |
10 |
$(DataRows) |
The number of row in the dataset (not including meta data). |
10,000 |
$(DataValues) |
The number of columns x rows in the dataset (not including meta data). |
100,000 |
$(FileCreatedDate) |
The date the file was created, in ISO format. Only available for file input. |
2020-08-18 |
$(FileCreatedDateTime) |
The datetime the file was created, in ISO format. Only available for file input. |
2020-08-18T18:00:00 |
$(FileName) |
The name of the file, including it's extension. Only available for file input. |
myfile.csv |
$(FilePath) |
The full path (location) of the file. Only available for file input. |
/Users/andy/Documents/myfile.csv |
$(FileSheetName) |
The name of the sheet. Only available for Excel file input. |
Sheet1 |
$(FileSizeBytes) |
The size of the file in bytes. Only available for file input. |
1,234,567 |
$(FileUpdatedDate) |
The date the file was last updated, in ISO format. Only available for file input. |
2020-08-18 |
$(FileUpdatedDateTime) |
The datetime the file was last updated, in ISO format. Only available for file input. |
2020-08-18T18:00:00 |
$(UserName) |
The name of the user (from the USER or USERNAME environment variable). |
Andy |
See also: