This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am attempting aggregate my raw data at the Index-level based on the Securities that match each of the filter criteria. I've been attempting to build a batch macro that would iterate through each of the Index filter combinations on the fields [International], [Strategy], and [Sub-Strategy] in the raw data. I am currently able to perform all of the steps to output the data almost how I want it, except the looping through each of the Index mappings based on the varying and sometimes more complex filter combinations. If I filter the mapping table down (manually) before feeding it in to the Control Parameters, I can accurately get the values I'm looking for with the downstream process steps, I'm just unable to get over the hurdle of how to set it up to loop through all of the possible combinations.
For example, Index 1 consists of Securities 1, 2, 4, & 5 because they match the criteria for Index 1 in the Index Filters Mapping example I've included. Securities 4 & 5 also match the the criteria for Index 3, therefore I would like to process those records through the downstream processing in the batch macro twice, but for each individual Index.
I hope it is clear in the pictures, but the Orange Index column is not part of my RAW data, but in effect that's what I'm essentially trying to tack onto the raw data so that I can then aggregate dynamically through all of the Index combinations. I've also included the spreadsheet of demo data if that helps as well. Thanks!