Adding new Column containing values based on condition

sajjan.jindal · May 14, 2019, 12:53am

Hi ,

I want to add a new column with values populated based on values from existing column. How can I include the condition. Looking forward for your suggestion.

Regards,
Sajjan

sajjan.jindal · May 16, 2019, 5:21pm

Hi,
I know that we can add a column but I am struggling to find if we can add values to the new column based on values from existing column. Hoping to get a solution.

Regards,
Sajjan.

ben · May 17, 2019, 4:01pm

Hello @sajjan.jindal,

What specifically are trying to accomplish? You can create computed columns for a number of cases. For example, below we are multiplying 2 values in a row and placing the result in a new column:

SELECT name, id, sales_per_quarter * average_sale AS average_sales_per_quarter 
FROM sales_table

sajjan.jindal · July 2, 2019, 12:53pm

Thx for your response - I was able to use the case statement and add new columns

Vikash_Singh · May 8, 2020, 10:08pm

@ben, i am also trying to create new Field based on condition like

Lets say i have old_field new _field
1 1 ==> sum of 1+0 =1
3 4 ==> sum of 1+3 =4
7 11 ==> sum of 4+7 =11

how i i create new field like this through Query

Vikash_Singh · May 8, 2020, 10:09pm

dacopan · May 9, 2020, 5:30am

you can achive it by using over window function

SELECT Id, DailyPoduction,
SUM (DailyPoduction) OVER (ORDER BY Id) AS CummulativePoduction
FROM MY_TABLE