Survey banner
The Dataiku Community is moving to a new home! Some short term disruption starting next week: LEARN MORE

HOW TO MERGE MULTIPLE DATASET INTO A SINGLE EXCEL SHEET? WHICH SHOULD BE DOWNLOADABLE.

prash_
Level 3
HOW TO MERGE MULTIPLE DATASET INTO A SINGLE EXCEL SHEET? WHICH SHOULD BE DOWNLOADABLE.

I HAVE ATTAHED REQUIRED OUTPUT.

0 Kudos
2 Replies
AshleyW
Dataiker

Hi @prash_ ,

You can use the multi-sheet excel export pluginn to export multiple datasets into a single multi-sheet Excel file.

 

Cheers,

Ashley

tgb417

@prash_ 

So from the image you shared it looks like you are trying to get multiple datasets of different layouts onto the same worksheet in an excell workbook.  Is that your intent?  Or was this just an easy way to show your results in a single image?

If I remember correctly @AshleyW method will work if you want to put different data sets into different worksheets in a single workbook file.  This is the typical use case in this community.  That said this approach may not work to put multiple different datasets into the same worksheet in an excel workbook.  Which appears to be what you are showing in your example image. 

If you need a more complicated layout taking multiple datasets and puts them into the same worksheet; that may be a bit more complicated project.

If you want to try a bit of python programming there are a few python packages that may help.  Here is a startup article that discusses some of the typical ones that people tend to use.  https://learnpython.com/blog/python-package-for-excel/

That said here are some discussions of doing this second multiple data frames on a single work sheet.

https://stackoverflow.com/questions/32957441/putting-many-python-pandas-dataframes-to-one-excel-work... 

This video seems to have an answer to this use case.

https://youtu.be/or2ibHcZkSY 

I hope that @AshleyW or my suggestions might be of assistance.  Let us know how you get on with your project.  

--Tom