topic Export objects from Salesforce and create Excel output in Data Quality

Export objects from Salesforce and create Excel output

Anonymous — Sat, 16 Nov 2024 09:38:45 GMT

Hi all,

I want to export some objects from Salesforce and put them in an Excel (CSV) file using Talend. The challenge is that I need the output file in a linear basis, for example:

- Account - Contacts: 1:n

- Account - Contracts: 1:n

The output should be 1 line per Account, first of all I think I need to export all 3 objects to Excel / CSV files and first denormalize the data using tDenormalize (write all related objects in 1 row, separated by a delimiter.)

Has anyone experience or an information how I can realize that?

Cheers,

Ingo

Re: Export objects from Salesforce and create Excel output

TRF — Mon, 12 Jun 2017 21:13:19 GMT

Can you give us an example of what you expect as a result?

Re: Export objects from Salesforce and create Excel output

Anonymous — Tue, 13 Jun 2017 07:42:07 GMT

The result should be 1 Account per line, e.g.:

Account name, Account city, Contact person 1, Contact person 2, Contact person 3, Contract information1, Contract information 2, ....

The output should be an Excel / CSV file, the challenge is that Contact and Contract tables are 1-many relations to the Account, I can deserialize these objects to have all contacts in one line with the ID of the Account, but I´m not sure how to get that data exported in a good way.