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.
Individually, each expression is matching as shown below:
But on "Test Rule Set" it throws the error -
Can someone help solve this? Is it because rule builder won't work on a Sub Classification key?
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.
The reason why I mentioned for the change in the structure is cause:
Rule Builder will not work on sub-classification
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
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)
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?