You might have noticed me using these in a few of the previous examples. The idea is that you create an empty table that you can concatenate to. The number one reason I do this is to be explicit. I know Qlik can and will auto-concatenate, but I want to be extremely clear in what I am doing, so that if there are any bugs I don’t have to troubleshoot code that has some behind the scenes magic.

Another reason to do this is you can establish the format of a field. This initialization of a table with the formats will override later formatting attributes.

 Placeholder:
Load
    Text(Null()) as TextTest,
    Num(Null(),'0000') as NumTest,
    Timestamp(Null(),'YYYY-MM-DD hh:mm:ss') as TimestampTest
AutoGenerate
    (0);
    
       
Concatenate(Placeholder)
Load
    1 as TextTest,
    Num(1,'#,##0') as NumTest,
    Now() as TimestampTest
AutoGenerate
    (1);
    

Concatenate(Placeholder)
Load
    'Two' as TextTest,
    2 as NumTest,
    Date(Floor(Now()),'MM/DD/YYYY') as TimestampTest
AutoGenerate
    (1);

Which returns: