user078054

I am a bit of a newbie here... Do you recommend I get the data into that form using Beast Mode or Magic ELT? Thanks! 

Yeah – my first Magic ETL flow. Success! Thanks so much, you saved me tons of time. Just a couple of questions: Question #1: I couldn't find a formula tile, is the formula tile in all of the releases yet? I was able to work around it though, since the Group by and Join gave me what I needed and I could do the rest in a…

Thanks so much. You saved me lots of thrashing in the beast mode. I will try this in Magic ETL. I will take awhile, I have a learning curve. But I will come back and mark as solution as soon as it works. 

Thanks so much, you nailed it! I was missing materials in the material column. I so appreciate the help. Once you said it, it was obvious what was happening.