About Venkat

Venkat · 03-19-2025

Hi ,I have 'Year' column, 'Week Number' with respect to the year, 'Day' number column(i.e. 0 for Sunday,1 for Monday,2 for Tuesday,..6 for Saturday).I need date format using these 3 columns.Any help on the date column achieving using Year, week Numbe...

Venkat · 06-10-2025

Hi msinha,Please find the below points.Scenario:1Incorporate the Date column(Minimum Aggregare function) into the insight to consider it as a dimension find below options.i) Create a materialized view (MV) and join it with the base table. This would ...

Venkat · 06-02-2025

Hi msinha,Create a bridge table containing key columns from Table A and Table B. Join these two tables (Table A and Table B) in the bridge table using the appropriate join type based on their relationship(e.g., inner join or left outer join) using MV...

Venkat · 05-27-2025

Hi,Steps)1. Please Convert the Year and Quarter values to a date format as outlined below.To accomplish this, the date function necessitates three columns: Year, Month, and Day.Convert the Quarter value to the starting month of the quarter. Specifica...

Venkat · 03-24-2025

Hi cckya,Please find my thoughts below.One idea is that data loading is inherently tied to the table's structure. Any changes—such as data type alterations or adding new columns—might necessitate a complete reload of the table. Therefore, allowing mo...

Venkat · 03-20-2025

Hi, I have followed the below steps. i)First, I converted the year column to the starting date of the year using the following Date formula:date(concat(string(<Year Column>),'-01-01')) ii)Next, I used the addDays formula to get the derived Date colum...

User Statistics

User Activity

calculate first day of week in date Format

Re: Alternative to Level-Based Formula in Aggregate Insight (Without Using MV)

Re: Issue with Aggregation Logic Using Conditional Joins Across Multiple Tables

Re: Issue with Retrieving Quarter End Date Based on Prompts

Re: Allow Schema Edits During Load Plan Execution

Re: calculate first day of week in date Format