Problem:
Consider the following scenario in Spotfire:
A data table was created by joining two data sources. Both of the data sources are embedded inside DXP file using the stored data option. Data sources are occasionally reloaded by users manually. How can I display the reload datetime of each data sources in Spotfire text area?
Resolution:
Perform the following operation to each of the data source node (AE and DM in this case).
1. Click on 'Loaded data' step (lower left part) in the Data canvas
2. From the three-point ellipsis icon, select 'Add transformations'
3. Apply calculated column transformation with following syntax
DateTimeNow()
4. The resulting data table will contain two calculated columns with reload datetime for data source AE and DM. Add dynamic items in text area to display the value of these columns as text.