Hi benny,
The Peek function is one of the data transformation techniques and an inter-record script function that allows us to literally peek into previously-read records of a table and Returns the values of the fieldname in the record specified by row in the internal table tablename. Data are fetched from the associative QlikView database. Fieldname must be given as a string (e.g. a quoted literal). Returned values are used to evaluate a condition or to affect the active record (the one being read).
The function takes one mandatory parameter, the field name into which we will "peek", and two optional parameters, a row reference and the table in which the field is located.
For example, expressions like:
peek (‘Price ' )
This expression will return the value of Price in the previous record read (equivalent to previous (Price)).
peek (‘Price ', 2)
This expression will return the value of Price from the third record in the currently-being-read table.
peek ('Price', -2)
This expression will return the value of Price from the second last record in the currently-being-read table.
peek (‘Price ', 0, ‘Table’)
This expression will return the value of Price from the first record read into the input table labelled Table.
Please check below posts where peek function is used in real time scenarios:
Populating-a-sparsely-populated-field
Master Calender Creation
The Group by is a clause used for defining over which fields the data should be aggregated (grouped).
groupbyfieldlist ::= (fieldname { ,fieldname } )
Group by must include the fields that are not within an aggregate function, for eg:
table2:
Load
Category,
Name,
Max (Date) as MaxDate
Resident table1 Group by Category, Name .
Regards
Neetha
