Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Here is the sample code,
Transactions:
Load
TransLineID,
TransID,
mod(TransID,26)+1 as Num,
Pick(Ceil(3*Rand1),'A','B','C') as Dim1,
Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,
Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,
Round(1000*Rand()*Rand()*Rand1) as Expression1,
Round( 10*Rand()*Rand()*Rand1) as Expression2,
Round(Rand()*Rand1,0.00001) as Expression3;
Load
Rand() as Rand1,
IterNo() as TransLineID,
RecNo() as TransID
Autogenerate 1000
While Rand()<=0.5 or IterNo()=1;
Comment Field Dim1 With "This is a field comment";
What happens to the below mentioned line ? Why it is used ?
Comment Field Dim1 With "This is a field comment";
It is nothing but a comment in order to let different developers know the meaning of the field , you can find it here
This used for understand of each comment for Data model level.
Qlikview Comment Tables WITH by Fields and Tables - YouTube
It is nothing but a comment in order to let different developers know the meaning of the field , you can find it here
Thank you bro