Hello, all;
I thought this was going to be a straightforward exercise, but it's not working out too well. :-) I've got a substantial dataset that I need to carve up based upon the values in three attributes. Once I have the separate collections, I need to add additional data rows in each collection. This data is based upon a template that needs to be inserted after every row in each collection.
So, what I did was the following:
LoopValue 1
Filter on attribute 1
LoopValue 2
Filter on attribute 2
LoopValue 3
Filter on attribute 3
When I do this, I get the expected result; collections broken down by category, subcategory, and sub-subcategory. At this point, I need to get rid of the extraneous attributes before adding in the the templates.
I tried adding a Trim statement inside LoopValue 3. I trimmed by subset and chose the attributes that I wanted to get rid of. Reviewing the example set at the input and output of the Trim statement shows that it is not taking effect. Is this happening because I'm trying to execute inside a loop?
