cancel
Showing results for 
Search instead for 
Did you mean: 

fundamental capstone 3.3

conorn_7
New Contributor III
New Contributor III

dont know what mistake im making here, will attach code and error below. have to find all the trades in the tradeContext table where exQuality is false (bad trades)

conorn_7_0-1650411138253.pngconorn_7_1-1650411160037.png

 

1 ACCEPTED SOLUTION

LeahS
Moderator Moderator
Moderator

Hello @conorn_7,

The assessment shows that you are getting a type error.  Can you run 'meta' on table 'x' please?

What type should exQuality be? In your query, you are saying that exQuality is a symbol rather than a boolean.

Here in my example, you can see the metadata for my table and the 'type' error returned when I run a query expecting exQuality to be a symbol when it is in fact a Boolean.

Spoiler
LeahS_0-1650471313457.png

Whereas, if I comply with the metadata for the table, expected results are returned:

Spoiler
LeahS_1-1650471384264.png

Hope this helps,

Leah

 

 

View solution in original post

1 REPLY 1

LeahS
Moderator Moderator
Moderator

Hello @conorn_7,

The assessment shows that you are getting a type error.  Can you run 'meta' on table 'x' please?

What type should exQuality be? In your query, you are saying that exQuality is a symbol rather than a boolean.

Here in my example, you can see the metadata for my table and the 'type' error returned when I run a query expecting exQuality to be a symbol when it is in fact a Boolean.

Spoiler
LeahS_0-1650471313457.png

Whereas, if I comply with the metadata for the table, expected results are returned:

Spoiler
LeahS_1-1650471384264.png

Hope this helps,

Leah