topic Re: How can I use the wildcard facility in CI studio. in SAS Customer Intelligence

How can I use the wildcard facility in CI studio.

georgeous — Wed, 21 Sep 2016 10:49:57 GMT

Hi, I have a field called LINK_URL in CI Studio. This field contains URLs from our email broadcasts that our customers have clicked on.

This field has a datatype of Character and a level of nominal.

I want to create a selection where the Link URL value contains the word "clothing"

I am unable to use the wildcard facility for this field -

I've done Like: clothing* but I get an error message.

I've noticed I can use the Like operator on other character fields but where the level is ordinal.

Does this make a difference.

How can I use the wildcard with my Link URL field.

Thanks

Georgina

Re: How can I use the wildcard facility in CI studio.

VinayUjjini — Thu, 22 Sep 2016 15:09:01 GMT

Hello Georgina:

You can enter wildcard searches using the % symbol. In CI Studio, once the data item is open, please click on the edit button to the right and in the next window, choose 'Like' operator. In the value section, use % as wildcard search. Please remember that this is case sensitive.

Another way is to open the data item and in value, type in Like:%el%

If you are searching for the word Help.

Hope this helps. I attached some screenshots for your benefit.

Please let me know if you have any questions.

Thanks,

Vinay

Re: How can I use the wildcard facility in CI studio.

georgeous — Thu, 22 Sep 2016 15:16:52 GMT

Hi, this doesn’t work.

I don’t have a Like Operator – I think it’s something to do with the datatype.

If I enter the Like: %value% manually, then I get an error message telling me that the Like operator is not allowed.

[cid:image001.jpg@01D214EC.AFFCBFA0]

Re: How can I use the wildcard facility in CI studio.

SteveMarshall — Thu, 22 Sep 2016 15:29:45 GMT

I believe Like can only be used on Character Fields that have no Metadata values. So if your field has a list of values available (with or without counts), I don't think you can use Like. To workaround, Go to Definitions workspace in CI Studio and create a new Selection / Calculated Item. Give it a name and in expression, select the Data Item that is the field you want to pattern match. Specify the proper Subject Level and Type: should be Character. Save the calculated item. Now in your Campaign, you should be able to use the new Calculated Item in Select Node and see the Like operator when you click the Select Values icon in the Values section

Re: How can I use the wildcard facility in CI studio.

georgeous — Thu, 22 Sep 2016 15:38:51 GMT

This worked a treat.

Thanks ever so much!