locked
MDS_EXCEL add in RRS feed

  • Question

  • I Created a subscription view(SQL View) in MDS using the data from MDS excel(Sheet1) add in now I need to add a new column to the view coming from different table in SQL DB and send back the data to the same excel(sheet1).
    Can anyone help me with this?

    thanks

    Monday, November 2, 2015 6:23 PM

Answers

  • When you say a different table, is it a different table/view in MDS or other SQL database?

    If it is from other database, I think Power Query in Excel is the right tool.

    http://www.bing.com/search?q=power+query

    Power Query is already integrated with Excel 2016, if you are using 2010 or 2013, you need download and install the addin separately.

    1. Load the data from the View

    2. Load the data from the table

    3. Do the join in excel

    • Proposed as answer by Vincent Chen (X) Monday, November 2, 2015 7:22 PM
    • Marked as answer by Charlie Liao Monday, November 16, 2015 9:06 AM
    Monday, November 2, 2015 7:22 PM