Data Type issue

[Aakanksha_chandak]

In my workflow, the data types (VString, double, etc.) get changed whenever there's a new input or any other change in the flow, I want the type to remain fixed i.e., whatever has been set at the start of the flow should remain constant throughout the flow.

[FrederikE]

Hey @Aakanksha_chandak,

You can pull in a select tool and change the data types to "xxx : Forced" - this locks the type, even if the input would be different.

[caltang]

You can also use Dynamic Select on the name, and use the functions to force the data type to be consistent. So if you get new fields, but if they share certain characteristics such as their names, then Alteryx can get the proper data type for you.

[Aakanksha_chandak]

I already have select tool, do I use another next to the select tool?

[caltang]

Maybe you should provide us with some sample data and give us the scenario which you want to force a certain data type on a certain field..?

That will be more helpful, no?

[Aakanksha_chandak]

  

 These 2 images are from start and end of my workflow, there are so many more tools in flow.

[caltang]

Not an image, an export of your workflow…

To export a workflow go to: Options > Export Workflow. Kindly do NOT send a "Save As" copy.

[Aakanksha_chandak]

sorry but the data is confidential.

[caltang]

Use sample data - random one… think out of the box. 

Then state your requirements on what you want to select and then give some examples of when the data type changes.

[Aakanksha_chandak]

when you make all the fields in the column random blank, data type gets changed to bool, which was earlier VString, so I want the data type for column random to be VString irrespective of the column being blank or having data inside