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

prash_
prash_ Registered Posts: 17

Answers

  • Ashley
    Ashley Dataiker, Alpha Tester, Dataiku DSS Core Designer, Registered, Product Ideas Manager Posts: 161 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
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,598 Neuron

    @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-worksheet

    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.

Setup Info
    Tags
      Help me…