none
table.combine execution error RRS feed

  • Question

  • Hi all,

    Can someone help with this query, please?  I'm trying to combine 2 tables from web page in single query.

    let
        Source = Web.Page(Web.Contents("http://finance.yahoo.com/q/op?s=BAC&m=2016-07")),
        Data1 = Source{1}[Data],
        Data2 = Source{2}[Data],
        Data3 = Table.Combine(Data1, Data2) as table,
        #"Changed Type" = Table.TransformColumnTypes(Data3,{{"Strike", type number}, {"Symbol", type text}, {"Last", type number}, {"Chg", type number}, {"Bid", type text}, {"Ask", type text}, {"Vol", Int64.Type}, {"Open Int", Int64.Type}})
    in
        #"Changed Type"

    Syntax is clean but execution error as follows:

    Expression.Error: 2 arguments were passed to a function which expects 1.
    Details:
        Pattern=
        Arguments=List

    Many thanks.

    Tuesday, July 12, 2016 12:15 PM

Answers