Classification Rule Builder not working on a SubClassification key

marishg69668790

21-06-2019

Hello,

I am trying to split an Address into - Street1, Street2, City, State, ZIP, Country - from a field "L3MG Original Address" which is part of a feed into Adobe, and therefore part of a Classification table with key "Listing ID".

I created a Subclassification on "Address" for the six items -  Street1, Street2, City, State, ZIP, Country -.

Then in Rule Builder, used regex  ^(.*)\|(.*)\|(.*)\|(.*)\|(.*)\|(.*)$  to split the address as shown below.

1776877_pastedImage_0.png

Individually, each expression is matching as shown below:

1776899_pastedImage_2.png

But on "Test Rule Set"  it throws the error -

1776900_pastedImage_3.png

Can someone help solve this? Is it because rule builder won't work on a Sub Classification key?

Thanks,

Accepted Solutions (1)

Accepted Solutions (1)

hyderziaee

Employee

25-06-2019

You are right, as the rule builder works on the key value (which is the value in the variable), and not the classification value.

Sub-classifications are to be used when a single key can only have a specific classification, and that classification can have a specific sub-classification. If for a single key, there can be two different sub-classification.

In this case, I do not think you need a sub-classificaiton. You can change the structure in the Admin section. And then use the Rule Builder for your automation.

Regards,

Hyder

Answers (6)

Answers (6)

hyderziaee

Employee

01-07-2019

@Andrey, I missed your question.

The reason why I mentioned for the change in the structure is cause:

  1. Rule Builder will not work on sub-classification
  2. Apart from the structure, there is no other place where you would actually see the reports as a sub-classification, which makes it unnecessary if not required. Here the values can be simple the classification of the actual value, and do not have to be sub-classification
  3. Sub-classification in my opinion should only be used if the key can never be in two sub-classifications, and if the classification needs to be done through file upload (and not rule builder)

Regards,

Hyder

marishg69668790

25-06-2019

HI @hyderziaee

Could you explain further what you mean by change the structure to normal classification?

The situation is, we are receiving a feed with some 33 fields for some Listings data. The key is listing_id. One of the fields in the feed is an address value which is further needed to be split into Street, city, zip etc.

I have had a similar experience previously also, where when we try to do regex on a subclassification key, it doesn't work as expected. SO my concern is - is it not possible to apply regex on a sub-classification item?

Thanks for any help here.

marishg69668790

25-06-2019

Hi Balaji,

I tried the regex you recommended. It is still throwing the error "Invalid Action on a Key"

I doubt it has something to do with the subclassification key!

Thanks,

hyderziaee

Employee

21-06-2019

From what I can see, this is not a case for sub-classification. change the structure to normal classification, and then use the rule builder.