Forum Discussion

ak77's avatar
ak77
Post Patron
3 years ago
Solved

Multiple columns to Multiple Rows in power query

hi Team,   I have 3 million records with 8 columns coming from DB table . i need help to get the fast way in power query to transpose 1 record to 3 rows as below: Col4,Col7 should be transposed un...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    In our file itself, just paste the M code.  It will work fine.

ak77's avatar
ak77
Post Patron
3 years ago

Thanks Ashish. i will check and get back to u 

ak77's avatar
ak77
Post Patron
3 years ago

Ashish_Mathur , can u please share the pbix file

  • foodd's avatar
    foodd
    Community Champion
    3 years ago

    Just paste the powerquery-m Ashish has listed as a solution into a new blank query.  It runs without issue.

    • ak77's avatar
      ak77
      Post Patron
      3 years ago

      Hi Ashish_Mathur ,

       

       

      I need a help please.

      for the attached dxp i tried the same logic.. but its failing with extra null values. can you please help.

      i need a 2 new columns for Client_Returns_Data Table

      1."Benchmark"--> which has 3 transposed rows from table columns class_scheme_node_name,class_scheme_node_name_benchmark,ExcessReturnsHeader
      2."Returns"-->which has 3 transposed rows from table columns log_portfolio_base,log_benchmark_base,Excess_Return

      all the other colums values should be repeated. Thanks again

       

      https://drive.google.com/file/d/1G98E9zzrzqg4eBqZQLfeftzne-xGSgg5/view?usp=sharing

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        I am clueless about your question.  May be some one else can help you.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    In our file itself, just paste the M code.  It will work fine.