How to write all datasets from datastore into one csv file with multiple lines?

[Christoph]

Hi guys,

I want to export all content from a datastore (currently 3) into a csv file with multiple rows and a header.

What I did so far:

• Experiment with the csv module didn’t work at all, I either got empty cells or [object] or something
• Trying to convert the text worked basically but now I have 3 operations means 3 .csv files instead of one

Can you help me how to get everythin into one .csv pls?

[ponvaskon]

Hi @Christoph
You should use the Create CSV (advanced) module and specify the data structure that you’re using in the data store module. After that you will be able to map the data properly.

[Christoph]

Hi @ponvaskon ,
thanks for responding to my issue. Unfortunately I still get empty data from the array.

What I did:

Test-run with the 3 data records from my data store
view output bundle.
Create new datastructure, paste the example record.
Save.

[ponvaskon]

@Christoph

1. I think you shouldn’t specify the key here.
   
   
2. Do you have empty values in your table?

[Christoph]

Hi @ponvaskon ,

i tried to delete the key from the structure but i still get empty data. My datastore is pretty simple and there are no empty values.

[ponvaskon]

@Christoph please share the scenario blueprint.