Multiple Comma in output data table

Help
1

Hi Friends,

I merged two datatable and try to get data in output data table.
I got data but it contains multiple comma so that it gives empty row in excel (First row).
How can i solve this.

PFA…

1,1,E,100,OT,Estate,

,Abc,8,Y

,New,99,N

,Old,99a,Y

2

@Rup_1

Sorry I didn’t get you. Could you please tell more details about the issue.

Are you missed column headers or what ?

3

Hi @Rup_1
The Output data table activity will convert your data in datatable to string in CSV format.

If you want to export data in datatable to Excel, then you can using Write Range in Excel Application Scope to do that.

image
image768×619 15 KB

*Checked AddHeaders in Options of Excel Application Scope for add column name of datatable(if any)
image
Sample workflow
outputDataTable.zip (18.4 KB)
I hope this information will be useful to you :blush: