Forum Discussion
Dicken
Post Prodigy
Post ProdigyPower Query Structured lookup
Hi, Can someone help or at least point me in direction of information on a structured lookup; example position operator table { 0 } , so the starting point is [ A = 1 = [A = 2]] = a...
There are some more examples that may confuse you. If you can understand them, then you understand "field access" (and projection) and the keyword each.
// Example 1 [A = 1, B = 2][[A], [C]]? // Example 2 #table({"A", "B"}, {{1, 2}, {1, 3}})[[D]]? // Example 3 let _ = [ A = 1, B = 2 ] in [A] // Example 4 let _ = [ A = 1, B = 2 ] in _[[A], [C]]?
DickenPost Prodigy
Post Prodigyjust to add having had al look , I knew using Table [ [ Column] ] was projection, but would not have thought to search for that so i've learned something already.
ZhangKun
Super User
Super UserThere are some more examples that may confuse you. If you can understand them, then you understand "field access" (and projection) and the keyword each.
// Example 1
[A = 1, B = 2][[A], [C]]?
// Example 2
#table({"A", "B"}, {{1, 2}, {1, 3}})[[D]]?
// Example 3
let
_ = [
A = 1,
B = 2
]
in
[A]
// Example 4
let
_ = [
A = 1,
B = 2
]
in
_[[A], [C]]?