Build LookML Objects in Looker: Challenge Lab GSP361

[ricardocalleja]

Hi there,

Has anyone completed “Build LookML Objects in Looker: Challenge Lab GSP361” I asked for help on the support chat and the provided me a workaround. However I’m stilll stucked at the task:

### Join the view to an Explore

I pasted this code on the order.view 

  join: order_items_challenge {
    type: left_outer
    sql_on: ${order_items.order_id} = ${order_items_challenge.order_id} ;;
    relationship: many_to_one
  }
 

But still no success. Any thoughts guys? 

[blackraven]

Hi, i’m also stuck at the same join view step. My codes:

  join: order_items_challenge {
    type: left_outer
    sql_on: ${order_items.order_id} = ${order_items_challenge.order_item_id} ;;
    relationship: many_to_one
  }

Because the order_item_id is defined in the default codes. But no success.

What is the workaround given by the support chat?

[blackraven]

I have managed to complete this lab, but I think there's a bug in the last 5 minutes

Build LookML Objects in Looker: Challenge Lab GSP361
See my solution: https://youtu.be/DP_oXW8MGcY