Fundamental capstone query 1.3

Academy Support
1

in ques 1.3 of the fundamentals capstone, we are asked to obtain the option_id column from the date partitioned trade table. i have done this by applying 

get `:2020.08.03/trade/option_id 

and then repeating this with all the other dates. is there a more efficient way to do this.

when i did the above i assigned the trade data for each date to a,b,c,d respectively like 

a:get `:2020.08.03/trade/option_id 

b:get `:2020.08.04/trade/option_id 

etc. 

to store the option_id data in a variable called uniqueOpts, I removed the attribute from each of these lists by 

#[`;a b c d] and then assigning 

f:a,b,c,d

followed by 

uniqueOpts:distinct f to get the distinct values.

is this a correct methodology?

2

Hello @conorn_7,

I would recommend qSQL here and suggest querying the table:

exec option_id from select distinct option_id from trade

This has been previously discussed here. 

Happy Coding,

Leah