Use conditional operators to filter arrays: >
, <
, >=
, <=
, =
, !=
.
Filters should be the same on the ith+1
marker and all other markers if you want to keep only matching rows. Use an Alias to simplify report maintenance.
Filter with strings as shown in the example below.
Filter the loop index as shown in the example below.
People |
---|
People |
---|
People |
---|
People |
---|
People |
---|
People |
---|
{d[i , age > 19, age < 30].name}
{d[i+1, age > 19, age < 30].name}
John
Bob
{d[i , type='rocket'].name}
{d[i+1, type='rocket'].name}
Falcon 9
Falcon Heavy
{d[i, i < 2].name}
{d[i+1, i < 2].name}
Falcon 9
Model S