I will have an Excel workbook with numerous tabs. Each tab has unique data but the columns and headers are the same.
Each tab in the Excel Workbook will be updated daily or weekly.
In Spotfire I need to combine the data from each tab into a common table in order to generate graphs etc.
What is going to be my best way to do this?
Do I bring each tab/table into Spotfire then join the data using "add rows" or do the "add rows" directly from the file/Excel?
Thanks for any thoughts or ideas