treysmithdev

SET vTP = '------------------'; // Trace Prefix 

Trace $(vTP) Loading Data;

data:
Load
	'Test' 	as data_name,
    Rand() 	as random_number
AutoGenerate
	(100);

treysmithdev

// *******************************************************
// ** Data
// *******************************************************

data:
Load
	Num(MakeDate(2020,01) + IterNo())								as %date,
	RowNo() 														as id,
    Pick(Ceil(Mod(RowNo(),4))+1, 'North','West','South','East') 	as region,
    1000 + (Ceil(Rand()* 4)) 										as %product,

treysmithdev

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET FirstWeekDay=6;
SET BrokenWeeks=1;

treysmithdev

/*
    Example:

    Chart has 3 columns (2 Dims, 1 Msr)

    date_num | dim | msr
    ---------|-----|-----
    43556    | B   | 25
    43556    | C   | 26
    ....

treysmithdev

Numbers:
Load * Inline [
Num
Zero
One
Two
Two
Three
];

treysmithdev

//	****************************************************************************
//	**  
//	** 	Reduce Tables
//	**
//	****************************************************************************

/*
		File: 		vRT_v1.0.qvs
		
		Version: 	1.0