BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
keiwo
Obsidian | Level 7

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,

 

1 ACCEPTED SOLUTION

Accepted Solutions
Dmitry_Alergant
Pyrite | Level 9

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

3 REPLIES 3
Dmitry_Alergant
Pyrite | Level 9

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
keiwo
Obsidian | Level 7

Hi Dmitry,

 

within the SELECT node, is this statement valid

 

Like: %Home%Phone%

 

Thanks,

Mrityunjay_Kuma
Fluorite | Level 6

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
How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

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