Salesforce Manual Query - child relationships

One Star

Salesforce Manual Query - child relationships

Using tSalesforceInput you can specify a manual query, e.g.
"Select Firstname,Lastname,Account.Name from Contact where Lastname like 'A%'"
How can I access the field Account.Name within an expression in tMap? You don't seem to be able to specify a column name with a '.' in it?
One Star

Re: Salesforce Manual Query - child relationships

Hi
Yes. Talend doesn't support you specify a column name with a '.' in it.
"Select Firstname,Lastname,Account.Name from Contact where Lastname like 'A%'"

Specify the query manually and edit the schema with a column 'Accoount_Name'.
Try this. Can column map the field Account.Name automatically?
Wait for your feedback.
Best regards!
Pedro
One Star

Re: Salesforce Manual Query - child relationships

It works! Awesome!