Output in specific order

Question

Hi everyone,

One of the options when updating a datateam table (from which denodo views are then updated) is "Append Existing".

Is it possible in the output tool to give an instruction as to where the data gets appended, i.e. at the top or the bottom?  The data automatically gets added at the end of the previous data.  I would like to see it append at the top.

Thank you for helping,

Rouche

IraWatt · Answer

Hey @Roche,

Interesting question I don't think Alteryx has a one click button for that. From what I understand a Database table is not a list it is a set therefore it has no inherent 'order'. To order it you need a column (for instance a date column which you can order by in queries). As its a set Inserts statements always just append to the bottom. What you could do is create a temporary table in the order you want and then overwrite the pre-existing table.