I need to get a comparison of sales in 2020 and 2021 for each store name and need to create a graph that shows trends of sales 2020-2021. currently, I’m using this query, but still not sure about the correct ...
databaseanswers.net Latest Questions
I want to know how to parse json if key is dynamic, how to define path in such cases in bigquery ? PFA image with JSON format. image_json_format I am trying to get the, endTime values ...
I try to find common clusters in a large table. I have my data in Google BigQuery. My data consists of many transactions tx from different user groups. User groups can have multiple ids and I try to cluster all ...
I have run through this error twice, and it gets on my nerves. It is an incomplete uploading of the webpage and its functionalities. However, it has something to do with my PC because I try to enter Big Query ...
I have this table with item and an intermediate group like this: Item I_Group A 1 B 1,2 C 1,2 D 1 E 2,3,4 F 3 G 4 H 5 I 6 J 4,5 I would like to put together the items that have an intermediate group in common like this: Item F_Group A,B,C,D,E,F,G,H,J 1 I 2 the grouping must have to be done in "chains" as ...
I would like to create as many columns as there are values in a field in a row. item group A,B,C,D 1 B,C,E 2 E 3 E,G,J 4 H,J 5 I 6 In fact, i try to split and convert the values inside a column into new columns but i don’t find a ...
SELECT createdAt,paidAt,deliveryStatus, purchasedBy, paymentProvider, CASE WHEN paidAt IS NOT NULL AND deliveryStatus IS NOT NULL THEN 'Completed' WHEN paidAt is null and deliveryStatus null then 'Unpaid' WHEN paidAt is not null ...
After to have group the item based on first criteria we obtain this result. My_table (reference in the SQL script below) item group 1,6 1 2 2 3,5 3 4,5 4 6 5 7,10,11 6 8,10,11,13 7 9 8 12,15,18 9 14 10 14,15,18,20 11 21 2 This group is an intermediate group. So, to find the final group, we explode the intermediate group to see what ...
I have an input table which has a list of all queries run in Bigquery. I need to create two columns one with the dataset name and other with table name. The queries example is as follows (some could be nested). ...
I have two tables in BigQuery with records ordered by a ranking. Given a ratio of integers, I want to be able to join both tables, keeping the order of the ranking and the proportions of the ratio of integers.