Error while evaluating document

sqwgglz

02-02-2018

Hi,

I'm attempting to enrich data from a table that has a 1-N relationship with my recipient table into my delivery so I can make the content conditional on a number.

This is my workflow:

1409167_pastedImage_1.png

I have a list of my mailable customers which has an additional query to select only those who met the criteria.

1409187_pastedImage_6.png

In my enrichment, I only want 1 column, where the "brand code" is equal to "BE"

1409178_pastedImage_3.png

The columns I'm enriching with are the one's below...

1409179_pastedImage_4.png

Here's the advanced join condition so I only pull data where the brand code is equal to BE.

1409177_pastedImage_2.png

I think my logic is correct however when I try pull in a field I've enriched I get this error in the Preview.

1409192_pastedImage_13.png

1409166_pastedImage_0.png

Can anyone see where I'm going wrong?

Any help would be greatly appreciated.

Thanks

Kevin

Accepted Solutions (1)

Accepted Solutions (1)

sqwgglz

26-04-2018

Hey all,

Sorry for the late reply.

So I found out that the preview system wasn't working, but on sending a full test to myself, the above actually worked and calculated the points correctly.

We can mark this as closed.

Thanks

Kevin

Answers (10)

Answers (10)

sqwgglz

27-02-2018

Apologies, I've been away from the business so have not had chance to implement the suggestions.

Will attempt today and reply ASAP


Thanks again

shrawans3153003

Employee

06-02-2018

Hello,

Could you please try the following and see if it helps

Open Split Object

·         Click on “First subset"

·         Click on “Previous” to go to “Targeting and Filtering dimension”

·         Click on Schema dropdown menu

·         Select “schema”

·         Click Next

·         Click on Finish

·         Apply same on other subset

·         Save workflow