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 |
Solved! Go to 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:
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: