I have two data sets A and B, both of them are information for Products. A for features and B for sales records.
Since both of them have millions of rows and more than 30 columns, join the tables will hurt performance.
So I built two workbooks for each of them.
I'm wondering could I start with the workbook A, filter down to a small set of Products use different criteria.
Then, go to the workbook B and look for the sales records for these Products?
I have them embedded in webpage through the API feature.
Could I create a button to jump to the workbook B?
What is the best way to do this?
Retrieving data ...