As the title questions, is it possible to dynamically populate segment code with data from a specific field? A simplified example scenario I am thinking of is if I have 3 sourceIDs and a secondary field with other data, let's say color. Is there a way to use a split or cell filtering query to select the 3 sourceIDs individually, and then update the segment code with whatever color corresponds to that record?
So in the end, I could have cell 1 selecting sourceID 1 and the segment code would dynamically populate as 1-Black, 1-Red, etc depending on what is in that color data field for the individual record. And then I would be able to do that for each sourceID so I could just have 1 cell per sourceID instead of having to set up a cell for each combination of sourceID and Color.