Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

Dynamically merge columns when columns appear and disapear

Hi   I have a step in my transformations that merges all the columns in my dataset. However some days there will be less columsn and other days there will be more. Which is causing errors Is there ...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago

    Hello, cottrera 

    Table.CombineColumns(#"Transposed Table", Table.ColumnNames(#"Transposed Table"),Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged")

     

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
3 years ago

Thank you for responding so quikly