Plan, execute, measure and optimize customer experiences

How to apply LIKE statement

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

How to apply LIKE statement

Hi,

 

In my SELECT node, I chose a field called "PRICE PLAN DESCRIPTION" and i wanted to select plans descriptions that contained the words

 

home and phone

 

How would that be done in the VALUE field within the node.

 

Thanks,

 


Accepted Solutions
Solution
‎02-09-2017 09:46 AM
Contributor
Posts: 46

Re: How to apply LIKE statement

Hi,

 

There are two solutions for your request.

 

1) The Select node supports applying Like criteria on some data items, but this is not always available. According to the User Guide, the data item must not "contain metadata". In technical terms this means a custom attribute "Metadata=None" specified for this data item in the Information Map Studio.

 

Screen Shot 2017-02-03 at 14.03.23.png

 

In this case, however, you will lose an ability to select subscribers by clicking checkboxes in front of a prepopulated list of available price plan descriptions.

 

If you need both to be able to select descriptions by checkboxes from a list, and apply "LIKE" criteria - you may want to add this column to the information map twice, as two separate ddata items.  One will have "metadata" enabled (and so show you checkboxes), and another won't have it and will support the LIKE criteria.

 

2) As a short-term gap solution to get by before you are able to introduce changes to the information map, you can create a calculated item with a formula like the following:

 

CASE WHEN

upcase(<<root.Price Plan Description>>) LIKE "%HOME%" or upcase(<<root.Price Plan Description>>) LIKE "%PHONE%"

THEN 1 ELSEEND

 

Best regards, Dmitriy.

-------
Dmitriy Alergant, Tier One Analytics

View solution in original post


All Replies
Solution
‎02-09-2017 09:46 AM
Contributor
Posts: 46

Re: How to apply LIKE statement

Hi,

 

There are two solutions for your request.

 

1) The Select node supports applying Like criteria on some data items, but this is not always available. According to the User Guide, the data item must not "contain metadata". In technical terms this means a custom attribute "Metadata=None" specified for this data item in the Information Map Studio.

 

Screen Shot 2017-02-03 at 14.03.23.png

 

In this case, however, you will lose an ability to select subscribers by clicking checkboxes in front of a prepopulated list of available price plan descriptions.

 

If you need both to be able to select descriptions by checkboxes from a list, and apply "LIKE" criteria - you may want to add this column to the information map twice, as two separate ddata items.  One will have "metadata" enabled (and so show you checkboxes), and another won't have it and will support the LIKE criteria.

 

2) As a short-term gap solution to get by before you are able to introduce changes to the information map, you can create a calculated item with a formula like the following:

 

CASE WHEN

upcase(<<root.Price Plan Description>>) LIKE "%HOME%" or upcase(<<root.Price Plan Description>>) LIKE "%PHONE%"

THEN 1 ELSEEND

 

Best regards, Dmitriy.

-------
Dmitriy Alergant, Tier One Analytics
Occasional Contributor
Posts: 8

Re: How to apply LIKE statement

Hi Dmitry,

 

within the SELECT node, is this statement valid

 

Like: %Home%Phone%

 

Thanks,

New Contributor
Posts: 4

Re: How to apply LIKE statement

Hi,

 

Use condition

 

            LIKE: %home
 and     LIKE: %phone

 

in  Selection criteria, See the attachment for CUST_NAME    LIKE: %S

 

Br,

Mrityunjay Kumar


Customer_like.jpg
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 246 views
  • 2 likes
  • 3 in conversation