Suggestions for combining multiple tabs from Excel

[christopher sawtelle 2]

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

[Richard Pobi]

The first option is the better. If eachtab of the excel workbook has the same number of columns/names then use "add rows". If the number of columns from each workbook is different but share a common column(primary key) then use "add columns".