Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
please find the attched file of data...
estimation from date & estimation to date .. field needs one date field.. where date fields like.. 1st, 2nd, 3rd etc date should be there..
i know this will work with interval match but how to use.
please suggest
Hi
PFA
Refer this to learn about intervalmatch.
check the attached PDF and the QVW it will help you understand the interval match function
Do you want to create new rows having new date field along with existing data having values from FROM DATE to TO DATE?
try to generate the Dates like below
Data:
Load * ,
date(estimation_from_date +iterno()-1) as EstimationDate
From Table
while estimation_from_date +iterno()-1 <= estimation_to_date ;
Hi
PFA
Refer this to learn about intervalmatch.