Forum Discussion

Balaji_Pandiyan's avatar
Balaji_Pandiyan
Regular Visitor
6 months ago
Solved

How to export table multiple columns into one column with ; seperator (csv format)

How to export table multiple columns into one column with ; seperator (csv format)   We have 6 columns in table, while export it should merge all columns merge with ; seperator   
Need Help
  • danextian's avatar
    danextian
    6 months ago

    Hi Balaji_Pandiyan 

    Not possible out of the box,. You can create custom column that combines the columns into one and export that instead. Or you can use TOCSV to combine all rows and column headers into a single of a csv string (this will return a single row).

     

Irwan's avatar
Irwan
Icon for Super User rankSuper User
6 months ago

hello Balaji_Pandiyan 

 

you can use merge column in power query.

Select all column you want to be merged, then use merge column with separator semicolon for ; separator.

= Table.CombineColumns(Table.TransformColumnTypes(#"Changed Type", {{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}}, "en-ID"),{"Column1", "Column2", "Column3", "Column4", "Column5", "Column6"},Combiner.CombineTextByDelimiter(";", QuoteStyle.None),"Merged")

 

Hope this will help.

Thank you.