preceding_load.qvs

Orders:
Load
 *,
  Date((OrderDate) + Floor(Rand()*45)) as ShipDate; // preceding load which loads after the previous calcs so we can add values to OrderDate
Load
	chr(round(25 * rand() + 65)) & chr(round(25 * rand() + 65)) & chr(round(25 * rand() + 65)) as Customer, // Customer name between AAA and ZZZ 
	round(1000000 * Rand()) as Target , // Target Revenue between 0 and 1,000,000 
	Date((Today()-600) + Floor(Rand()*600)) as OrderDate // Random Dates
AutoGenerate 50;