About nikhil_cr

nikhil_cr · 12-02-2024

Hi,I’m trying to generate a Row Number using the query below, but it seems that Incorta is not returning the correct results. I checked the same query in another SQL editor, and the results were correct there. It seems either I'm missing something or...

nikhil_cr · 07-10-2024

Hi,I'm trying to achieve a rolling sum with a max condition. Basically trying to do a rolling sum but before we roll the 1st row sum to the next row we have to check with a condition if the rolling value is less than or equal to Zero. If it is less t...

nikhil_cr · 05-07-2024

Hi,I have start date (File Date) and end date in the table and i want to repeat the rows for each day from start date to end date. Is there any way that I can achieve this in MV? Please see screenshot - Appreciate your help in Advance. Thanks.

nikhil_cr · 01-16-2024

Hi,I'm trying to write a query in MV (Spark SQL) which excludes the items ending with "_X" I understand underscore ("_") is single character wildcard in SQL and should be addressed as '%[_]x' or '%\_x' which will include the Underscore (_). But it s...

nikhil_cr · 12-01-2023

Hi, I'm trying to calculate avg value for each quarter based on the current Month completed.I have the below table and I'm trying to calculate the Avg value for each Quarter.Avg Revenue for Quarter Q1 = (1+2+3)/3Avg Revenue for Quarter Q2 = (4+5+6)/3...

nikhil_cr · 12-04-2024

I thought the same initially, so i casted the orderdate to date and doubled checked the data type in the table but still i did not get the desired results.Thanks for the response.

nikhil_cr · 07-17-2024

@JoeM : My bad, Its working. I made some mistake while reading the columns. FYI - one of our teammates found a solution using SQL - You can refer attached sql code.

nikhil_cr · 07-15-2024

@JoeM - Thanks for the reply, But your code is not giving me the rolling sum. @Spd_0303 - Yes they are dependent, except the 1st row. Once the stock on day for the 1st day is calculated, it will be our Initial Stock for the next day. see snip - St...

nikhil_cr · 05-08-2024

@anurag Thank you so much. It is working as expected.

nikhil_cr · 05-07-2024

Hi @anurag,I'm trying to pull the forecast details on a daily basis. I have this start date (File date) and end date, once I get the list of Rows between these two dates for each day - I can map them with my daily forecast table. I'm trying to achiev...

User Statistics

User Activity

Row Number Error in MV Spark SQL

Rolling Sum + Max Condition

Recursive Table in MV

Materialized views - Query ends with _X

Average value for Quarter - Dynamic

Re: Row Number Error in MV Spark SQL

Re: Rolling Sum + Max Condition

Re: Rolling Sum + Max Condition

Re: Recursive Table in MV

Re: Recursive Table in MV