Skip to main content
New Participant
Jul 5, 2024 7:54 AM UTC
Question

How to Export datastore to Excel if i have multiple table .

If I have four tables in a database how do I export them in a single sheet of Excel?

1

    4 replies

    stefanhelzle0001
    Brainy
    Jul 5, 2024 8:22 AM UTC

    Create a view in the DB and export from that.

    konduruc733182
    Inspiring
    Jul 5, 2024 9:28 AM UTC

    Not sure if you are asking to export all tables in a single grid/sheet or in 4 different sheets. If the first as Stefan mentioned create a view and use it for your requirement. If you want get those in 4 different sheets, and a script post the smart service and increase the counter by 1 and use choose the DSE and use the counter value in the sheet number.

    davidj137213
    Brainy
    Jul 5, 2024 9:01 PM UTC

    It depends on which data you need yo export.. but as Stephan said, the best approach is to create a view in your database , selecting the data you may need

    karumurua531442
    Participating Frequently
    Jul 6, 2024 7:46 PM UTC

    Hi [mention:820556802286420f85753e9006d09c76:e9ed411860ed4f2ba0265705b8793d05] Creating a view and export that into Excel using smart service.