- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Working with Dates in Data Load Editor QCC
good morning
apologies if this is the incorrect forum, i am struggling with one of the QCC courses :
Working with Dates in Data Load Editor
Create a Canonical Date Field on a data bridge table, i am getting the below error and have tried twice now from scratch::
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That data should be there from when you loaded the OrderDetails in the Data section of the script, see below from the video @ 1:57/ 9:55
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
FinestGranularity field is not available in OrderDetails table.
can you check the field name in model
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Take a look at the script in the screenshot where the OrderLineKey is duplicated and renamed to FinestGranularity
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you very much, this was completely my oversight, i had linked the 3 qvd files myself as opposed to using the script for the course, then gave each load a name but did not noticed the OrderLineKey as ....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That data should be there from when you loaded the OrderDetails in the Data section of the script, see below from the video @ 1:57/ 9:55
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
FinestGranularity field is not available in OrderDetails table.
can you check the field name in model
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Take a look at the script in the screenshot where the OrderLineKey is duplicated and renamed to FinestGranularity
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if you can share the code, that would be helpful to understand.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thank you very much, this was completely my oversight, i had linked the 3 qvd files myself as opposed to using the script for the course, then gave each load a name but did not noticed the OrderLineKey as ....