Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

customised functions

HIhow does Incorta supports on customised functions/formulaes. can we store frequently used user defined function/formulaes in Business schema and call them as and when required instead of re-writing the formulae each time. Is there any system limita...

MT10 by Ranger
  • 226 Views
  • 1 replies
  • 0 kudos

Resolved! split a word

Hican someone advise how to  extract the last/first  few letters of a word/string with and without delimitorsan example from excel point of view:Left(Orange,2) = Orright(Orange,2) = gergds 

MT10 by Ranger
  • 451 Views
  • 1 replies
  • 0 kudos

Resolved! Recursive Table in MV

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_0-1715103795522.png

Resolved! Period Based Incremental Refresh

Hi Team,Can anyone explain how to do period-based Incremental load based on the Ship_Date column(Date format. not timestamp)?In our current ETl tool, we delete the last 3 months(Ship_Date) records from the Data Warehouse table and load the last 3 mon...