Incorrect Type when running in cloud?

Question

Good Afternoon,

I have an Alteryx script that takes an excel file (admittedly Excel 95), does some manipulation and then appends this to a Tableau Hyper file.

Via desktop this works without a hitch. There are 16 columns and I have ensured by the last selection tool, that all of them are VWString type.

So, as noted this works fine on desktop, but upload this to the gallery and ask it to run manually (or via Schedule) and it will fail when writing to the hyper file with the error:

The Field "Cake" is not of the same type as the corresponding name table column in the Tableau Hyper Extract File.

But the problem is, it is, its the same file that I can write on the desktop without an error, but the cloud is falling over with this above error.

What can I do to fix it please?

Thank you

OllieClarke · Answer

@Bobbins the fact that data types are changing when run on server compared to local makes me think that there's something funky going on with the connections to the files, as Alteryx shouldn't be any different on server compared to local.
However, as a temp stop gap solution, if you choose VWString (Forced) as the data type in the select tool, then that means that if the data type does change, the select will ensure that it becomes a VWString (even though it is currently being read as a VWString).

Bobbins · Answer

As per image (corrected)

Thanks @OllieClarke

tab.JPG

OllieClarke · Answer

@Bobbins can you show the configuration of the output data tool please?