Write multiple dataset into a single excel sheet or csv
Hi
I am a new user in Dataiku. I have seen instances where multiple datasets are written to a single excel sheet with multiple sheets using plugin or python.
But I want to write multiple datasets with different schema into a single sheet excel file/a csv file where a table with headers will be written after another table with different headers or different number of columns.
How can I achieve this? Could anyone please help?
Answers
-
Sarina Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 317 Dataiker
Hi @abhi503501
,
The built-in option that we offer for exporting multiple datasets to Excel is the "Multisheet excel export" plugin: https://www.dataiku.com/product/plugins/multisheet-excel-export/
This is probably the simplest option. If you really want to write everything to the same sheet, and the datasets all have different schemas, this is something you would need to handle through a custom Python recipe.
Thank you,
Sarina