Appending to tde file

[Hong_Hu]

Hi all,

I'm trying to develop a workflow that adds daily data into a Tableau tde file. My issue is that the daily data sometimes may miss a column or two. For example, the full variable lists are A,B,C,D, and for a certain date, I may only have A, B, C and on another date, I may only have A, B, D.

What is the best way to ensure that these daily data can be successfully append to the tde file? Thanks!

Best,

Hong

[danilang · Accepted solution]

Hi @Hong_Hu 

Use a Text input with the all the column names that you need to write to the tde.  Don't add any rows.  Follow this with a Select to set the correct type for each column.  Union this with your data.  Any missing columns will be added to your data with the correct type and null values.  

Dan