for some reason I don't understand, the function peek doesn't work. Maybe my example describes not my real need. I need a limitation of selected rows by a value of another table.
But I got a result with function Fieldvalue.
So the Syntax is
Select foo from table1;
let variable = FiledValue(foo,1);
Select baa from table2 LIMIT $(variable);
Hi, here's an example how I use peek for a similar task:
LOAD date#(left(@1,10),'MM-DD-YYYY') as UpdateDate
FROM [$(File)] (biff, no labels, table is [Sheet1$])
LETvCurrFileDate = num(date(peek('UpdateDate',0,'PARTS_date')));