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.

table

Which returns: