Participant II
Since ‎08-01-2021
‎01-04-2024

My Stats

  • 17 Posts
  • 0 Solutions
  • 4 Likes given
  • 1 Likes received

Yugali's Bio

Badges tumikosha Earned

View all badges

Recent Activity

I have 2 viewsOrders.view derived_table: { sql: select 1 as id, 100 as amount, 1 as customer_id UNION ALL select 2 as id, 200 as amount, 2 as customer_id UNION ALL select 3 as id, 300 as amount, 3 as customer_id UNION ALL select 4 as id,300 as amount...
parameterr: reg_exp { type: string default_value: "^(Act|(.*_Act))[A-Z]{1}[^_]*$" } derived_table: { create_process: { sql_step: -- regexp {% parameter agg_poc_src.reg_exp %} ;;If the parameter is selected the filter correctly show the first characte...
I want to query a table that have over 2k columns and its constantly increase the number of columns. We want to get the column names as string (like “Filed1,Field2,...”) from one query and use this list in another queryHow I can do that?DECLARE x STR...
I would like to select field names from one table and pass their list to another select.I know how to do this with DECLARE and EXECUTE IMMEDIATE (BigQuery dialect)But, they cannot be used inside DERIVED TABLEHow can I model something like this code?v...
dimension: value_num { type: number value_format: "0.##" sql:CAST (${value_string} AS FLOAT64) ;; }The result looks like: 25. ← Why “.” ? 3.19 8.3 How can I remove a trailing dot after 25 ?
Likes from