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?
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.