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.
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?
Thanks,
Solved! Go to Solution.
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
Views
Replies
Total Likes
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.
Hi hyderziaee,
Could you explain why the advice was to change the structure to normal classification?
Views
Replies
Total Likes
HI Arish,
Please try the below format,
Thanks,
Balaji
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,
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
@Andrey, I missed your question.
The reason why I mentioned for the change in the structure is cause:
Regards,
Hyder
Views
Replies
Total Likes