Forum Discussion

Dom87326's avatar
Dom87326
Helper II
4 years ago
Solved

Merge query settings steps

Hello,    I was wondering if there's a feature to merge multiple Query Settings applied steps for better user experience?  For example, in these steps below I do same ETL for multiple columns an...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Dom87326 ,

     

    If your Merge steps are always based on the Renamed columns , it would cause errors when you want to combine all Renamed steps later like:

     

    If not, I'd suggest you combine all Rename steps in Advanced Editor:

    #"Renamed Columns1" = Table.RenameColumns(#"Merged Columns",{{"Column1, "Rename1"}, {"Column2", "Rename2"}})

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Dom87326 ,

 

If your Merge steps are always based on the Renamed columns , it would cause errors when you want to combine all Renamed steps later like:

 

If not, I'd suggest you combine all Rename steps in Advanced Editor:

#"Renamed Columns1" = Table.RenameColumns(#"Merged Columns",{{"Column1, "Rename1"}, {"Column2", "Rename2"}})

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.