powerpeanuts
New Contributor III
since ‎2021.11.15
‎2023.08.09

User Statistics

  • 23 Posts
  • 0 Solutions
  • 20 Kudos given
  • 9 Kudos received

User Activity

Hi, I have a simple question: I have a list b:(1 5 6;9 10 76; 43 12 11) and I would like to take the nth indexed element from each list where n is a list, for example n = (0;2;1). So the output should be (1;76;12). What is the easiest syntax to do it...
Hi, is there a way to make select statements with multiple conditions in combinations? For example, for the table below: q)flip `date`data!(2023.05.20 2023.05.20 2023.05.20 2023.05.19 2023.05.19 2023.05.19;`a`c`b`b`b`c) date data --------------- 2023...
I remember in q, we can assign a temporary variable during select and use it again in the same column, but seems it is not working. For example, select (total+5)%(total:a+b) from t this should be same as select (a+b+5)%(a+b) from t What is wrong with...
Hi, in the select statement, we can easily do 5 xbar time.minute to group the data for every 5 minutes, what is the equivalent for doing like every 5 millisecond?
hi, how can we unpack nested column in a table? Thanks. e.g. t:flip `a`b!((1 2 3);((4 5 6);(6 12 23);)(12 36 14))) to t: flip `a`b1`b2`b3!((1 2 3);(4 6 12);(5 12 36);(6 23 14))