none
Convert List data in Cell to columns RRS feed

  • Question

  • Hi,

    Is there a way to convert List data in a cell to corresponding columns using Power Query?

    Thanks in advance.

    Regards

    Milind

    Tuesday, November 8, 2016 4:56 PM

Answers

All replies

  • Convert the list to a record and then expand the record.

    Here's some code showing how to convert a list to a record

    let list = {1, 2, 3}
    in Record.FromList(list, List.Transform(List.Numbers(1, List.Count(list)), (i) => "Value"&Text.From(i)))

    Tuesday, November 8, 2016 8:31 PM
  • Thanks Curt for the response.

    I am getting data as JSON from the system and has mix of data items .

    Some of them are returned as list and shown on Power Query Table as "List" within the cell on a columns, which can be expanded like below.

    Can we convert this data to corresponding columns.

    Regards

    Milind

    Wednesday, November 9, 2016 5:40 PM
  • Hi Milind,

    there seems to be a problem with the picture you've uploaded. Could you please try it again?


    Imke Feldmann TheBIccountant.com

    Thursday, November 10, 2016 12:26 PM
    Moderator