Using Magic ETL For One To Many
I have one dataset with many, many lines with a company number. I have another dataset with one line per company with plan values in it. I want to combine the two in Magic but don't want the Plan number to repeat over and over (flatten the plan?) in the combined dataset so that the summarized number per company number in the subsequent dataset equals the plan file with one row per company number.
Hopefully this make sense. I thought I was taught at one point how to do this in Magic, but drawing a blank.