Answers for "AutoGenerate"

0

AutoGenerate

// Create empty table and setting field types
Log:
Load
    Null()                     as [Log.Table],
    Num(Null(),'#,##0')        as [Log.Rows],
    Timestamp(Null())          as [Log.Timestamp]
AutoGenerate
    (0);
    

Fact:
LOAD
    TransLineID,
    TransID,
    "Num",
    Dim1,
    Dim2,
    Dim3,
    Expression1,
    Expression2,
    Expression3
FROM 
    [lib://QVD/SampleTransactions.qvd](qvd);


// Add Log record
Concatenate(Log)
Load
    'Fact'                    as [Log.Table],
    NoOfRows('Fact')          as [Log.Rows],
    Now()                     as [Log.Timestamp]
AutoGenerate
    (1);
Posted by: Guest on May-25-2021

Browse Popular Code Answers by Language