-
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 default ti…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 floats an…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 Group By and …1 -
Re: How to mix and match Data
First, we should solve problem #2. Then, we'll create a canonical lookup table from Number to City to solve problem #1. Use an Add Formula tile to make two new columns, Canonical Number and Canonical…2
