-
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()) a…1 -
Re: Can't get Group & Join to Work
Sure, add an ELSE 0 to the case statement.1 -
Re: Can't get Group & Join to Work
The issue is the comparison with that string, 'Nov 22, 2023 12:00:00 AM'. That comparison will first convert the left hand side to a string according to the Timestamp Format setting or the …1 -
Re: ETL error: "failed to convert value 'Infinity' from type 'Floating Decimal' to type 'Fixed Decimal'"
I'll just add some context for anybody still watching this issue. This comment is specific to Magic ETL; Beast Mode (Domo Adrenaline) works differently: Issues like this happen when you mix floa…2 -
Re: Remove duplicate unknown comma separated values within a single 'cell'
@Charlie Bantoft It sounds like you want this formula: GROUP_CONCAT(DISTINCT Model SEPARATOR ', ') Use the "Add Formula" button instead of the "Add Column" button in Gro…1
