Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
extract location field between 2 dates across 2 records
Hi all
I am new to Oracle BIEE and currently learning to use it to generate reports using drag and drop analysis.
I want to extract the location of my customers using a list of customers with various transaction date time. Appreciate any help here.
List of customers with transaction date time:
Customer ID Transaction date time
1 20/1/2019 18:00
2 22/1/2019 20:00
The data structure is like this:
| Customer ID | Event ID | Check in date time | Location |
|---|---|---|---|
| 1 | 1 | 20/1/2019 13:00 | Location 1 |
| 1 | 1 | 20/1/2019 14:00 | Location 2 |
| 1 | 2 | 21/1/2019 08:00 | Location 1 |
| 1 | 3 | 22/1/2019 15:00 | Location 3 |
| 1 | 4 | 22/1/2019 19:00 | Location 4 |
| 2 | 11 | 21/1/2019 08:00 | Location 5 |
| 2 | 12 | 22/1/2019 15:00 | Location 1 |
| 2 | 13 | 22/1/2019 19:00 | Location 4 |
| 3 | 21 | 19/1/2019 10:30 | Location 1 |
Answers
-
Not sure I understand your requirement here. What do you mean "extract the location"?
Just show the "Location" column per "Customer Id"?
0 -
Hi Christian
Sorry for not making the question clear and my poor english.
The table is the lookup table.
I need to tabulate the location into the list by looking at the table where the customer is by using the date and time in the list.
The expected answers are
Customer ID Transaction date time location of customer
1 20/1/2019 18:00 Location 2 (as customer checked in to this location at 14:00)
2 22/1/2019 20:00 Location 4 (as customer checked in to this location at 15:00)
0