Data type keep changing in the select tool every time I try to run an App.

Question

So I need all field to be strings, but when I upload a file with empty columns to an App then data type change automatically in the select tool to doubles. This result is errors the formula tools that follows. How can I force all string to all fields even when there is an empty column when I run an App? can I add an interface tool? which one would it be??

Thanks

philipmannering · Answer

If you haven't already, make sure that your Select Tool data types are set to String: Forced, not just string.

ArtApa · Answer

Hi @AmAm - You can change data type dynamically with a Multi-Field formula:

IraWatt · Answer

Hey @AmAm,

That's a very strange issue, do you have an example of the data or workflow which can cause this issue? My inital thoughts to get round it would be to do something like this:

The top text input just has dummy data, we can be certain that it will be always string as its unchanging. When its unioned because it #1 its data types will be used ensuring that everything will always be set to a string. Afterward the filter can remove the dummy records.

Allways string.yxmc