I want to put hard stop in the select tool

[Sshasnk]

I have different dataset but I want to pass only a few selected

Input1:

Name	last name	location
Alex	Tell	NY
Tim	Lars	LA

Input 2:

Name	last name	location	amount
Alex	Tell	NY	100
Tim	Lars	LA	50

Input 3:

Name	last name	location	sell	buy
Alex	Tell	NY	45	62
Tim	Lars	LA	45	12

Now, I want to select only Name, last name, and location only. In future the more columns will come but I alway want to force and select these 3 columns only.

sample output for Input 2:

Name	last name	location
Alex	Tell	NY
Tim	Lars	LA

[Felipe_Ribeir0 · Accepted solution]

Hi @Sshasnk 

If you use the select tool without the *Unknown option selected and with Name, last name and location selected, even if you have new fields they wont be selected

Here it is:

 

[DataNath]

Hey @Sshasnk, one option could be to use the Dynamic Select tool - you can essentially filter fields based on an expression here.

Based on name:

If they're always the first 3 fields, then you could also do so by position: