Hi,
In Pivot table we have some columns which contains comma in the data.So, When we are exporting to CSV with comma as a delimiter then it is shifting data to next column in flat structure.
How we can handle this issue without changing comma as delimiter in CSV export.
My Code →
if (type === “csv”) {
pivot.export.csv({
name: fileName,
//asFile: true,
flat: true,
rowDelimiter: “\n”,
columnDelimiter: “,”
});
}