When outputting a file to Tableau SERVER (format of output = HYPER), then format for a fixed decimal appears to be being picked up in Tableau as a STRING field when it should be a NUMERIC.
Is this a problem with Alteryx or Tableau?
The only change we have made is to update Alteryx into 2019.4 version, so this has to be the problem.
The problem doesn't happen if the field is a DOUBLE.
When the field is converted to fixed decimal and after exported it is indeed converted and seen as a string.
This is an alteryx issue. I would recommend you to add a select before the output and give it a double format to avoid the problem.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Regards
Thanks. It was never an issue until 2019.4 It's a mightily invconvient issue, as we will need to change the outputs in every workflow. Some workflows have multiple outputs.
Can't Alteryx correct this ASAP? I don't want to wait until the next version is issued. It would be much better to issue a patch and then download 2019.4.1.