Highlighted

Advanced join Condition in Enrichment Usage

Rishabh46

29-05-2019

Hi,

1761910_pastedImage_0.png

We are trying to use the Advanced join as shown above to a temporary table but we are getting Sql error at the time of delivery is trigger

The error shown below screenshot

1761911_pastedImage_1.png

However, if we use the Simple join it works perfectly

Please help us in understanding how to implement Advance join

Any reference document would also be fine

Thanks

Rishabh

Replies

Highlighted

bhaveshp8596869

29-05-2019

Hey Rishabh46,

Can you provide the logs within the Delivery Audit, have you added any additional fields as personalization? Has the delivery been created? Is this error after it was created, or before it hits that activity. Have you enabled any SQL logging? Is so, please provide this so we can look at what tables are throwing this error.

Thanks!

Bhav