I have a tableau workbook with calculated fields and using a TDE as data source. Whenever Alteryx is overwriting the TDE, these calculated fields (along with other meta data info) are lost.
I have searched forums on Alteryx/Tableau and Net in general and nobody seems to talk about it in practical terms. Either I am missing something obvoius OR everyone has accepted that fact that Alteryx+Tableau Kit is not supposed to be a repeatable solution (I doubt it).
So how are folks doing this? e.g. Alteryx outs put a dataset with two columns (A,B) and in tableau workbook I create a new column C (C=A/B). I dont want this calcualtion to be done in ALteryx since the A/B ration can change based on other dimensions in the data. If Alterys generated a TDE, the new export will contain columns A,B but will have no mention or records of column C (C=A/B).
Some folks have mentioned taking TDSX, unzipping it and then replacing the TDE file within the TDS, rezipping and then uploading the new TDSX to tableau server. This may work but kills the whole purpose of spending so much money on alteryx. (One can create a rollup on SQL server or have Tableau Server refresh the extract periodically with no intervention of Alteryx).
