Finding minimum during load

[dwfiv327]

I would like to find the minimum and maximum values of a field during the load process and store those values in variables.  Just putting LET vMin=Min(field); in the script doesn't work.  Any suggestions?

Daniel W. Farrow, IV

Business Systems Analyst

[sunny_talwar · Accepted solution]

Check the master calendar script where we calculate min and max of date to create the calendar

Creating A Master Calendar‌

Thing to note here is that you can't directly save min and max to a variable. You will have to do a resident load where you calculate min and max and then use Peek to save them in variable.

[dwfiv327]

Thanks.  This worked perfectly!