Force data type for empty data stream

Is it possible to lock the data types selected in a Select tool? The issue I'm running into is if the input dataset is empty, Alteryx (for some reason) sets all data types to double, causing many downstream tools to fail.

Since I know that the data types for the input fields will never actually change (but may be empty), can I not make sure Alteryx doesn't change them on its own?

Workflow

Accepted answers

Jonathan-Sherman

Hi @nrossin,

If i have an example of one column (Column 1), which is a string data type:

I could force the data type to be the string by selecting String: Forced

This "Forced" option is available to keep the data type as it is and not let it change.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

All comments

Jonathan-Sherman

Hi @nrossin,

If i have an example of one column (Column 1), which is a string data type:

I could force the data type to be the string by selecting String: Forced

This "Forced" option is available to keep the data type as it is and not let it change.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

nrossin

That is helpful for most datatypes, yes. I do not seem to have the option to force a Date, though?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703