cancel
Showing results for
Did you mean:

## May I please know how the over iterator is being used here?

New Contributor II

Which form of iterator is being used here? Thank you!

You can use the over iterator with ssr to replace multiple items.

(ssr/)["results_%div_%dept.csv"; ("%div";"%dept"); ("banking";"m&a")]

1 ACCEPTED SOLUTION
Contributor III

https://code.kx.com/q/ref/accumulators/#ternary-values

You can use a sample to see how it progresses:

({-1 .Q.s1 `x`y`z!(x;y;z);x+y+z}/)[0;1 2 3;4 5 6]
`x`y`z!0 1 4
`x`y`z!5 2 5
`x`y`z!12 3 6
21

And on the ssr example:

({-1 .Q.s1 `x`y`z!(x;y;z);ssr[x;y;z]}/)["results_%div_%dept.csv"; ("%div";"%dept"); ("banking";"m&a")]
`x`y`z!("results_%div_%dept.csv";"%div";"banking")
`x`y`z!("results_banking_%dept.csv";"%dept";"m&a")
"results_banking_m&a.csv"

3 REPLIES 3
Contributor III

https://code.kx.com/q/ref/accumulators/#ternary-values

You can use a sample to see how it progresses:

({-1 .Q.s1 `x`y`z!(x;y;z);x+y+z}/)[0;1 2 3;4 5 6]
`x`y`z!0 1 4
`x`y`z!5 2 5
`x`y`z!12 3 6
21

And on the ssr example:

({-1 .Q.s1 `x`y`z!(x;y;z);ssr[x;y;z]}/)["results_%div_%dept.csv"; ("%div";"%dept"); ("banking";"m&a")]
`x`y`z!("results_%div_%dept.csv";"%div";"banking")
`x`y`z!("results_banking_%dept.csv";"%dept";"m&a")
"results_banking_m&a.csv"

New Contributor II

Thank you very much! May I ask where is the documentation on "-1" used here?

New Contributor II

Handles to files and processes | Basics | q and kdb+ documentation - Kdb+ and q documentation (kx.co...

1 means send to stdout

-1 means send to stdout, then append a newline character