How to save an Output DataTable(String Datatype) into CSV File?

Help
6

Hey @nesachdeva

@nesachdeva Please follow this instruction :slight_smile:

If i am not getting you wrong then are you using “Output datatable activity” to see the output in a string format of a datatable and then trying to write into csv or excel file?

if it is so then instead of output datatable activity output assign datatable directly to the csv/ excel file.
that activity is only to show the output on the console.

still their i am giving an idea to convert the string data into a datatable :slight_smile: by the way.

Here i am attaching a sample workflow which is extracting the string based on “Space” but in your case split on the basis which you wants and here i am using single for-each because i am using counter for demo purpose if you wants column names as well dynamic based on string then use one more for-each and split that as well on the basis of your requirement then add that column and data row into the datatable.

please find the sample workflow to give you an idea.

SampleWorkflow.zip (3.5 KB)

Regards…!!
Aksh

2 Likes