-
Re: Group By Tile to JOIN Tile Produces Unexpected Result. Using an Output Tile as an Input Fixes It
Previews operate on a limited number of rows from their inputs, by default just 10k rows: This can cause Group By aggregates to look incomplete, Joins to miss when they should hit, and Filters to pro…3 -
Re: How to Join two Group By without matching pair column
Unfortunately there's currently no way to do this in a way that will dynamically adapt to the actual set of unique Requestor Organizations. If you can tolerate enumerating the Requestor Organizations…1 -
Re: How to Join two Group By without matching pair column
The Add Constant that comes right before the Append should add a constant "Project Id" with value -1. The goal is to create a table that has three columns that all correspond to columns in …1 -
Re: How to Join two Group By without matching pair column
Also, since this is missing from my original comment, here is the configuration for the "Correct for Dummy" Add Formula tile:1 -
Re: Can't get Group & Join to Work
What's happening there is pretty weird, I'll try to explain it: When you write a Group By formula, Magic ETL allows you to reference columns both inside an aggregate function (like SUM()) and outside…1
