Forum Discussion

fmerieux's avatar
fmerieux
Frequent Visitor
3 years ago
Solved

Slow performance with custom function applied to table

Hello everyone,   I have 3 different queries that contains list of articles and each query has a column that I want to apply to the other queries in order to have a comprehensive view of all the ar...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi fmerieux ,
    have you considered full outer join options for the merges?: Full outer join - Power Query | Microsoft Learn
    Otherwise, please post file with some mock-up data.
    I currently specifically don't understand the effect of the filters you are applying here:

        #"Keepit" = Table.SelectRows(#"FillDown",

             each [Level]<>0 or [#"Descript. synth."]<> null or [Index] = {Table.RowCount(TableDataConso)}[Index] )
    So very difficult to come up with alternative solutions here.

     

fmerieux's avatar
fmerieux
Frequent Visitor
3 years ago

Thanks ImkeF  for your reply

 

I thought about Left Outter join, but I don't know an efficient way to fill in columns of the left query with the right query that share the same names

 

Lets say I have "Column1" in both queries, after expanding my Outter Table, Column 1 will become Column1.1

 

I need to keep only Column 1 in the end but I have about ten columns like this and I'm afraid this would be worse than what I've tried

 

Any idea ?  Or am I missing something with the merge options ?

 

Thanks a lot