Freigeben über

Transform ANY nested table to Pivot Table with function query

  • Artikel

This blog post was moved here.

Comments

  • Anonymous
    October 18, 2015
    On the previous page of this tutorial, we used a function query FnUnpivotNestedTable to unpivot ANY nested
  • Anonymous
    October 18, 2015
    Earlier today I shared with you a function query here that unpivots ANY nested table into Excel and transforms
  • Anonymous
    October 18, 2015
    Would you like to use this technique on Power BI Desktop? Learn how here: http://blogs.technet.com/b/gilraviv/archive/2015/10/18/unpivot-any-nested-table-and-load-to-power-bi-desktop.aspx
  • Anonymous
    October 18, 2015
    Hi Gil. Great article. Than ks a lot.

    I think that there's a missing step in the article. Once you have unpivoted the other columns I think there must be a "Split column by delimiter" step. In it you turn the merged column into three columns.

    It is in the query included in the workbook, but somehow it did not appear in the written article.
  • Anonymous
    October 18, 2015
    Hi Vincente,
    Thank you for the feedback. You are correct. I added the missing step.
  • Anonymous
    October 20, 2015
    Hi Gil,

    Great post. I think it would be better if the sample file didn't still contain RANDBETWEEN because it makes cross referencing your query output with the input very confusing.

    Mynda
  • Anonymous
    October 21, 2015
    Hi Mynda,
    Thank you for reading. Following your recommendation I removed the RANDBETWEEN.
  • Anonymous
    November 08, 2015
    By now, if you read my previous posts in the series The Definitive Guide to Unpivot in Excel (main posts
  • Anonymous
    November 15, 2015
    Thanks for pointing out the link to create this in the PowerBI Desktop as well
  • Anonymous
    April 19, 2016
    To Follow