Help transform data structure better by power Query (multiple rows Headers)

  • Help transform data structure better by power Query (multiple rows Headers)

    Posted by DSC Communities on October 12, 2022 at 6:55 am
    • Hai Huynh

      Member

      October 12, 2022 at 6:55 AM

      Dear All,

      I have a date structure as below:
      Each Product has a SaleNumber and a RecipeNumber. It includes multiple ingredients: A, B, C, D, E (each ingredient has a code)

      I want to use Power Query to unpivol, transform to my structure better and logic more (sorry for my EN skill).
      May you help me!

      Thank you!

      ——————————
      Hai Huynh
      ——————————

    • James Watts

      Member

      October 13, 2022 at 3:34 AM

      Could you clarify what output you want ?Ā  And will the source file always have the same number of columns ?

      ——————————
      James Watts
      Business Intelligence Analyst
      ——————————
      ——————————————-

    • Adam Artur Boltryk

      Member

      October 13, 2022 at 11:51 AM

      Hi Hai,

      SaleNumber1, 2 and 3 you should have in measure at least from different source.
      Recipe 1, 2, 3 you should kick to DIM table and make relation.

      Than on column ‘NEW CODE’ just remove empty.

      Regards,

      ——————————
      Adam Artur Boltryk
      Business Analyst
      ——————————
      ——————————————-

    DSC Communities replied 3 years, 5 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Help transform data structure better by power Query (multiple rows Headers)’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!