Move script output to excel sheet

[Asmita7]

Hello Friends,

I am fetching data from a few tables through background script. I want to download the output in Excel sheet.

How to achieve this?

Is there any other way to fetch data from multiple tables apart from script ?

Thank you,

Your help and time will be appreciated.

[OlaN]

Hi,

I would suggest that you create a report or list (if possible) and then export the data to Excel directly from the Export UI action.

This is possible depending on the structure of the data you're getting, only if the data can be fetched from one table and dot-walking to the other tables.

There is also the possibility to create a Database view, if the above suggestion doesn't work.

[Asmita7]

Hi OlaN.

Thank you for your time.

I am fetching data from multiple tables. 3 tables. All 3 tables do not have a common field. But these are tables are related to each other. 

Please suggest.

Thank you

[OlaN]

Related to each other? Can the data be retrieved with related list conditions then?

Did you have a look at creating a database view?

[Ankur Bawiskar]

@Asmita7 

Please create a database view by joining those 3 tables and then create report on that database view.

lets users then export the report