Salesforce Manual Query - child relationships

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

It works! Awesome!