Merge Multiple Reports into DOMO

user04089
user04089 Member
edited March 2023 in Datasets

Hi,

 

We are using Box connector to grab reports into domo and merge that into the main dataset. Since we can only import one report a time through Box connector, other than creating couple more connectors, is there a way that we can have multiple reports into domo at the same time and then merge them into the dataset? Thank you!

Best Answer

  • Unknown
    Answer ✓

    Hi,

     

    As you said, each instance of a connector creates a distinct dataset. So your proposed method is the correct way to do it: create a connector for each report you want to read; then use Magic ETL (or other dataflow) to append or join those datasets.

     

Answers

  • Unknown
    Answer ✓

    Hi,

     

    As you said, each instance of a connector creates a distinct dataset. So your proposed method is the correct way to do it: create a connector for each report you want to read; then use Magic ETL (or other dataflow) to append or join those datasets.