How to return the text value of look up field rather than ID - SQL Query in Marketing Cloud

Asked Sep 11 '22 at 09:18

Active Sep 14 '22 at 15:05

Viewed 39 times

I am writing a query and when I select a lookup field "Acct/Customer name" the query return an ID (i.e 01111550023423) but when I go on Salesforce the actual field in the UI shows a actual name (i.e John Doe).

Do you know a way for me to be able to return John Doe rather than 01111550023423 while querying the same field.

edited Sep 14 '22 at 15:05

marc_s

732,580
175
1,330
1,459

asked Sep 11 '22 at 09:18

Paulene Ntsame-Assoumou

Can you update your question with actual input and expected output? – Prabhakar Reddy Sep 12 '22 at 02:24
What I have done is just query the contact object (via Account) and query field called FirstName and LastName. Thanks. – Paulene Ntsame-Assoumou Oct 05 '22 at 09:09

How to return the text value of look up field rather than ID - SQL Query in Marketing Cloud

0 Answers0