none
Getting value from a cell with a one element [table] RRS feed

  • Question

  • Hello, newbie on power query

    I'm getting a query from a webservice, and in two columns it returns [table] value along all its cells

    If I look into this cells, there is only one element inside, the question is, how can I get that that data?

    Because if I load into a worksheet it becomes a text cell with "[Table]"in it.

    Thanks :D

    Wednesday, January 29, 2020 5:07 PM

Answers

  • You can expand it in the Power Query Editor using the little "double arrow" icon on the column header. This will flatten the nested table(s) into the parent table.

    Ehren

    Friday, January 31, 2020 5:16 PM
    Owner

All replies

  • In the Power Query Editor, try clicking on the "[Table]" link in the cell.

    Ehren

    Thursday, January 30, 2020 11:44 PM
    Owner
  • Hi, thanks for the reply, the point here is getting that value into the table I want to load, because when I load it into a sheet, it keeps the [Table] value, as a string.
    Friday, January 31, 2020 8:58 AM
  • You can expand it in the Power Query Editor using the little "double arrow" icon on the column header. This will flatten the nested table(s) into the parent table.

    Ehren

    Friday, January 31, 2020 5:16 PM
    Owner
  • Ooh, I did understand it wrong.

    It worked, thanks :D

    Monday, February 3, 2020 9:47 AM