Four Stars

Export objects from Salesforce and create Excel output

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

Tags (2)
2 REPLIES
Twelve Stars TRF
Twelve Stars

Re: Export objects from Salesforce and create Excel output

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

TRF
Four Stars

Re: Export objects from Salesforce and create Excel output

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.