while you can create a calculated field for this along the lines of below against contact history and
Substr(max(CAT(Put(<</Contact & Response History/Contact Date>>,YYMMDD10.),<</Contact & Response History/Marketing Cell Code>>)),11)
It's not advised as it uses SAS functions that are not resolved in the Database and will pull data to the compute tier to resolve and would have negative performance impact.
A better option would be to create a database view that did a similar operation and then add the view to the info map.
Something like Create view MostRecentCH_Cell_Cd as
select ch.Customer_ID, Substr(max(Concat(To_Char(CH.Contact Date),cp.Marketing Cell Code)),11)
from cdm.ci_contact_History CH join cdm.CI_Cell_package cp on cp.cell_package_Sk = ch.cell_package_sk
group by ch.customer_ID
Note your example should just involve a single Transaction table.
... View more