BR_Code remains constant but other details keeps changing (in a day or two).
Recipient Schema has customer email id & @text1 field of recipient table has BR_Code so that it can be mapped with brData .
When I query Targeting dimension as Recipient & Filtering Dimension as brData and condition as BR_Code = 'A',it returns all customers in Recipient table with BR_Code as A but when I try to personalize BR_Manager_Name or BR_Manager_EMAIL_ID or BR_Manager_Phone#
it returns undefined.
The syntax I have used in delivery to personalize is <%= recipient.brdata_Recipient.BR_Manager_Name %>.
When I use <%= recipient.text1 %> for Branch Code, it works perfectly fine but <%= recipient.brdata_Recipient.BR_Manager_Name %> is not working.
Can you please also let us know the Cardinality between recipient and BR_Code schema ?
It might be to do with the cardinality, if you have 1-1 or N-1 cardinality from Recipient to BR-Code you can use it directly it in delivery. Otherwise you to enrich it using enrichment activity first and than use it as targetdata in delivery.