I’m trying to add a column on this table and stuck for a little while ID Category 1 Date Data1 A 1 2022-05-30 21 B 2 2022-05-21 15 A 2 2022-05-02 33 A 1 2022-02-11 3 B 2 2022-05-01 19 A 1 2022-05-15 null A 1 2022-05-20 11 A 2 2022-04-20 22 to ID Category 1 Date Data1 Picked_Data A
Tag: bigquery-udf
How to find the index of an element in an Array in BigQuery
is it possible to find the index of an element in a array in BigQuery? The idea is to find the index of an element to grab a different element in the row below. So for example, for this case I need to find the index of ‘status2’ to grab the respective entering date of the status after status2, that
Calling a native function within a UDF in bigquery
I am trying to convert our legacy functions into standard SQL and so by using UDFs as a gig to reuse the old function names with the native functions. Here I have my UDF to_char and inside use the parameters to run FORMAT_DATE but when I execute it even though a routine is created I get errors with no additional
I want to de-dupe records in BigQuery with max column value on specific column with expression
company | email | phone | website | address Amar CO LLC | amar@gmail.com | 123 | NULL | India Amar CO | amar@gmail.com | NULL | NULL | IND Stacks CO | stack@gmil.com | 910 | stacks.com | United …