Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Extracting Date Range Data in HCM Extract with Looping Logic
Jeeva R
Rank 2 - Community Beginner
Dear Champions,
I'm currently attempting to extract multiple values from an HCM Extract by utilizing a for loop, with the criteria being the start date and end date. The following SQL query demonstrates this concept:
select date'2021-06-08' + level - 1 dt
from dual
connect by level <= (
date'2021-06-14' - date'2021-06-08' + 1
)
These logic needs to be applied in HCM Extract. My objective is to return all the dates that fall within the range of the start and end dates. Is it possible to achieve this through in the HCM Extract.
Regards,
Surya
1