M7XBeastandCursor
ff096b51b5
Clean package repo for Gitea installs via packages.yml git URL. Co-authored-by: Cursor <cursoragent@cursor.com>
14 lines
741 B
SQL
14 lines
741 B
SQL
with
|
|
all_num_rows as (
|
|
select * from {{ ref('validate_numbers') }}
|
|
)
|
|
|
|
select *,
|
|
case when {{ f2dq.valid_number('number') }} then 1 else 0 end as is_number,
|
|
case when {{ f2dq.valid_number_decimal_point('number') }} then 1 else 0 end as is_number_decimal_point,
|
|
case when {{ f2dq.valid_number_decimal_comma('number') }} then 1 else 0 end as is_number_decimal_comma,
|
|
case when {{ f2dq.valid_number_percentage('number') }} then 1 else 0 end as is_percentage,
|
|
case when {{ f2dq.valid_number_percentage_point('number') }} then 1 else 0 end as is_percentage_decimal_point,
|
|
case when {{ f2dq.valid_number_percentage_comma('number') }} then 1 else 0 end as is_percentage_decimal_comma
|
|
from all_num_rows
|