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