In Spotfire Analyst, you can view the Source Information, i.e. data source and transformations for the data tables in the current analysis. This article describes how you can use the Application Profiler tool to gather this type of information for many analyses at once.

This article describes how to get the information about source of the data used in the Spotfire analysis files using the Application Profiler tool.

All

1. Start the Application Profiler (Tools > Diagnostics) from Spotfire Analyst and load the library/local folder where the analyses of interest are located.
2. Once loaded, click on Start to generate the output tables (in the Spotfire Text Data Format (STDF))
3. Click on Show Analysis to create an analysis from the output tables. 
4. The output table of particular interest here is named ApplicationProfiler_DataTables.stdf by default. The Source Information can be found in the column named Source Information.

A sample of what Source Information may contain:
---------------------------------------------------------
    1. Select Data > Add data...
        Source: Data loaded from file
        Type: Microsoft Excel Workbooks
        Location: C:\Work\Data\Sales Data.xls
        Worksheet: Large Sales Data Set
        Data loaded at: 6/21/2022 10:41 AM
        Data was added as a new data table
    2. Data > Data table properties > Relations
        Added relation: [Sales Data]. [Type] - [Sugar Content]. [Food]
---------------------------------------------------------
5. Try filtering the data on that table as shown in the below screenshot or write an expression(as below) for a calculated column to extract any specific data that you are looking for.


Note: For some use cases (e.g. identifying the list of Spotfire analysis files using a particular Information Link or data connection as a Data Source), Searching the library could also be a better alternative.
See this article for more details,  https://support.tibco.com/s/article/How-to-identify-the-list-of-analysis-files-using-a-particular-Information-Link-or-data-connection-as-Data-Source
 

Doc: Application profiler:

• https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/diag/diag_application_profiler_dialog.htm

Doc: Details on Data Table Properties – Source Information:

• https://docs.tibco.com/pub/sfire-analyst/latest/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_details_on_data_table_properties_source_information.htm

KB Article: How to identify the list of Spotfire analysis files using a particular Information Link or data connection as a Data Source: 

• https://support.tibco.com/s/article/How-to-identify-the-list-of-analysis-files-using-a-particular-Information-Link-or-data-connection-as-Data-Source