May be like this
LOAD Key,FirstValue(Value) as Value
Group By Key;
An example :
LOAD Key,FirstValue(Value) as Value Inline [
]Group By Key;
LOAD * INLINE [
it is working just for previous example but if i do not know in which row the key is how can determine the middle parameter in peek function which is the previous example 0
from the following data :
if i have the first ID whixh is 00000000-0000-0000-0000-000000000000 and i want to get the value of the Name which is "Battle"
How can i do it using Peek function but if i do not know the location of this record (only in this example the record in the first row) . i now only the value of ID
so what will be the middle parameter of the peek function !!!