0 Replies Latest reply on Apr 20, 2016 10:55 AM by Zhaoyang Jiang

    Jump between Workbooks - maybe thought API?

    Zhaoyang Jiang

      Hello Forums,

       

      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?

       

      Thank you!

      Zhaoyang