Adding File Metadata Columns to Tables
There may be instances when your analysis will require the use of file metadata. Data Prep Studio provides an easy means to add the metadata of delimited text, Excel, HTML, JSON, PDF/Text report, and XML files as columns to your tables.
The table below describes the metadata items you can add to a table.
|
File Type |
Metadata Columns |
| Delimited text |
File created File last modified Source filename |
| Excel |
File created File last modified Source filename Sheet number Sheet name |
| HTML |
File created File last modified Source filename |
| JSON |
File created File last modified Source filename |
| PDF/Text report |
Report column Report file created Report file last modified Report filename Report file number Report line Report page count Report page PDF Producer |
| XML |
File created File last modified Source filename |
You can add metadata to your table by performing the steps below.
-
In the Prepare window, select the table with metadata you wish to include in your table. At the bottom of the Change History panel, click the Metadata Columns button.
You can also expand the context menu of any column in the table and then select Column > Add or Remove Metadata Columns from the options that display.
-
In the Add or Remove Metadata Columns dialog that displays, tick the boxes of each metadata item you want to bring into your table. Alternatively, tick the box for Name to add all of the available metadata items to your table.
-
Click OK when you are finished.
© 2025 Altair Engineering Inc. All Rights Reserved.