locked
Can I get Excel table to use config table, more easy ? RRS feed

  • Question

  • Can I get Excel table to use config table, more easy ?

    I create config Table on Excel worksheets for Power Query dynamic configuration, import path, start date, etc.
    I want to know more easy way.

    // Table Name : configTable
    [configName] , [configValue]
    configA , 1
    configB , 2
    configC , 3

    // M, for get ConfigB's value

    let
       valueB = ( Table.SelectRows(Excel.CurrentWorkbook(){[Name="configTable"]}[Content], each [configName] = "configB") ) {0} [configValue]

    in
       valueB

    Regards,
    Yoshihiro Kawabata

    Wednesday, October 2, 2013 12:51 AM

Answers

  • Hi Yoshihiro,

    Your proposed solution sounds about right. It wasn't that difficult I guess! : )

    Thanks for all your questions, feedback and support to Power Query!

    M.

    Thursday, October 3, 2013 5:33 AM