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.

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.