Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI 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