rco Domo Employee

  • Re: How to Duplicate Rows

    This will be easier in the near future with the Join tile ON clause and the Series (row generator) tile. For now, the solution to this problem is described here. There's more than one answer; the mor…
  • Re: How do I use window function date ranges in DOMO ETLs?

    Regrettably, window functions aren't supported in Magic ETL formulas, and as you've already determined it's not possible to express that window frame using the Rank & Window tile. Including the f…
  • 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…