This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Docs Learn Support
Help
Docs Learn Support
nikhil_cr
Cosmonaut
since ‎10-06-2022
‎09-16-2026

User Statistics

  • 30 Posts
  • 2 Solutions
  • 15 Kudos given
  • 2 Kudos received

User Activity

Resolve Many to Many relationship Joins issue via Incorta Virtual Joins

09-15-2026
Goal:I have a CustomerGroup table where a customer can appear multiple times (one row per Concept per time period), so customer_code is not unique in this table. I want users to filter by Concept on a dashboard and have that filter apply to our sales...

Save only last X Period History in Incremental Tables

01-13-2025
Hi,I have an incremental table where I load data once a week. It’s been 6 months, and the data has already exceeded 30 GB (~500 million rows). Now, if I want to restrict the history to only the last 3 months, is there a way to do this? I don’t want t...

Row Number Error in MV Spark SQL

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...

Rolling Sum + Max Condition

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...

Recursive Table in MV

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.
View more
Copyright © 2026 Khoros, LLC