Autogenerate() function is used in the load statement to automatically generate data. This function is particularly useful when you need to create a table of random numbers or a range of dates.
However, the Autogenerate() function has a key limitation, the field list must not contain expressions that require data from an external data source or a previously loaded table. This is because Autogenerate() is designed to generate data independently, without relying on external data sources or previously loaded tables.
The only exception to this rule is when you refer to a single field value in a previously loaded table with the Peek() function. The Peek() function allows you to retrieve a single field value from a previously loaded table, which can then be used in the Autogenerate() function.
This design ensures that the Autogenerate() function can operate independently and efficiently, without the need to access external data sources or previously loaded tables. It also helps to avoid potential issues with data dependencies and ensures that the data generation process is predictable and consistent.
I hope this helps.
