Apply filter in typology | Community
Skip to main content
K
kaushalendras48
Level 2
October 17, 2019
Solved

Apply filter in typology

  • October 17, 2019
  • 4 replies
  • 5246 views

Hi ,

I am trying to make a typology rule which checks the filter criteria if the data is not matching with recipient id and employee code then it will apply.

Filtering with recipient id is easy but how to apply to value which is coming in target data but not from recipient.

example

Recipient  

1

2

3

other is coming from employee table

1    a

1   b

2    c

Before delivery target data of campaign previous  has  below data which is passed to typology

1 a

1 b

1 c

3 a

while applying this typology we should have data should be written in broadlog as

1c

3 a

Rest data go to exclusion log

1    a

1   b

2    c

Can anyone suggest how to achieve.  we are able to do that if its only id field using table exist command but not sure how to include second in comparison

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jyoti_Yadav

    Hi,

    You can exclude user before reaching to delivery. Design your workflow such that data which is not valid should not go to delivery.

    If it's mandatory that you want to do it in typology, then you can define linking in table so that you can filter on both table.

    Thanks.

    4 replies

    asktam1410
    asktam1410
    Level 3
    October 17, 2019

    if employee is prod schema - you can create a reverse link between recipient and Employee table.

    Then in the typology rule you can use recipient schema as well as recipient linked schema

      K
      kaushalendras48Author
      Level 2
      October 18, 2019

      Hi,

      Sorry i missed the link the employee table has only

      code and description

      which coming from separate table which is coming from segment value which is user is defining after the selection.

      so the data is made only on temporary data set created in workflow.

      Is there any way to look into temp schema created before delivery to be referred in typology.

      Jyoti_Yadav
      Jyoti_YadavAccepted solution
      Level 8
      October 18, 2019

      Hi,

      You can exclude user before reaching to delivery. Design your workflow such that data which is not valid should not go to delivery.

      If it's mandatory that you want to do it in typology, then you can define linking in table so that you can filter on both table.

      Thanks.

        Sourav_Sadhu
        Sourav_Sadhu
        Level 2
        October 18, 2019

        Hi,

        You can't really achieve this without creating a link between the recipient and this table. If you are fine to do this then you can use Typology or else please a Split activity before the delivery so that you can get the waterfall count and it'll not be in the target list.

        Sourav

          Terms & ConditionsAccessibility statement

          Loading footer...