Deleting Memory in the Select Tool

[Swetha_L]

My input data has different field names each time and I do not want the Select tool to save any information.

Currently, I am having to reorder the columns each time. Is there a way to avoid it?

[binuacs]

@Swetha_L if you select the unknown variable in the select tool it will select the new fields each time when you run the workflow, un-check the unknown field in the select tool

[Gaurav_Dhama_]

Are you refering to the scenario like this?

This generally happens when you assign a manual data type. These stay in memory as Alteryx tries to remember what you assigned to a field. You can use 'Auto Field' instead to automatically assign the correct data type.

[Swetha_L]

Apologies I should have been more specific.

 I do want the new fields to be included. I do not want the field names saved from the previous run. Currently, fields that are common to the previous run and the current run are processed first, and then the new fields in the current run. This is messing up the order of fields from the input.

I want the select tool to take fields from the input in the same order. This will be possible if the Select tool is void of any memory from the previous processing. Is it possible to do this?

[danilang]

Hi @Swetha_L 

Can you provide sample input files.  One with the original field names and one with the new ones.  Can you also provide the correct output.

Dan  

[binuacs]

@Swetha_Li think the select tool will not change the order. may be can you try running your workflow by turn off the AMP engine ? 

[sureshmg]

If you select "Forget All Missing Fields" in the select tool , it will remove all missing fields.