Mattsco Dataiker

• Activity
• Posts9
• Comments116

• Re: How can I fill in empty cells of a column with values of the corresponding rows from another column?

  Mattsco

  October 2018
  In a preparation script, use the processor Formula with the coalesce function : The function can work with multiple columns: coalesce(null, null, "string") -> "string" Matt
  1 ·

• Re: Scenario Conditional on Dataset Metric

  Mattsco

  July 2020
  Hi Nik, You can add a check on the metric row_count. A check is a condition that depends on a metric, here the check would be a success if it's above or equal 1: If not the check is going to fai…
  1 ·

• Re: partitioning

  Mattsco

  June 2020
  Hi Venu, When you use partitioning feature, in all recipes you need to configure (in input/output tab of the recipe) the partition dependencies. If your input is partitioned by day, the output is not…
  3 ·

• Re: now() formula in prepare recipe not translatable on SQL engine

  Mattsco

  May 2020
  Hi, No, you should upgrade.
  1 ·

• Re: now() formula in prepare recipe not translatable on SQL engine

  Mattsco

  May 2020
  Hi Rajesh, In the formula processor, you can write the SQL translation to be used when you use the SQL engine. So you can check in redshift what is the function to get the date of today and write it …
  1 ·

Next