Forum Discussion
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
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).
3 Replies
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.
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).
Hi Balaji_Pandiyan,
Thank you for reaching out to Microsoft Fabric Community.
Thank you Irwan and danextian for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
