Working with Dates in Data Load Editor QCC

[KWHITEHURST]

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::

[Lisa_P · Accepted solution]

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

[qv_testing · Accepted solution]

FinestGranularity field is not available in OrderDetails table.

can you check the field name in model 

[Lisa_P · Accepted solution]

Take a look at the script in the screenshot where the OrderLineKey is duplicated and renamed to FinestGranularity 

[qv_testing]

if you can share the code, that would be helpful to understand.

[KWHITEHURST · Accepted solution]

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 ....