community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Field Index or Position ID

Hello All,

Can you add the flexibility to access fields based on its position or index like a[1], a[2],... a[n]. a[1] being the first column. Also an option to get max[a] can give the last column and min[a] give the first column. In this way, we can easily subset the dataset. Most cases, we are handling survey data which has 1000s of columns and when we need to select certain columns, we have to manually select the column checkbox and its painful to select 100s of columns. It will be nice if there is an option to select based on ID or index. It will also be useful while doing multi-field formula with more number of fields, because currently there is no option to write formulaes based on field Name column in it. 

Regards,
Jeeva.
2 Comments
Atom
If I am understanding your question, the Dynamic Select tool can handle this.  

1.  Use the pull down to "Select via a Formula"
2.  Expand the "Fields" group in the Variables tab and navigate to the last field option "FieldNumber"
3.  [FieldNumber] = 1 returns the first column

Does that work?
Bolide

I'd very much like the multi-field tool to offer the option of designating field position rather than field name. I was going to detail my "why", but it's pretty tedious and boring to anybody but me. Suffice it to say that until Alteryx implements the ability to designate the header and data rows in one shot, I have a lot of finessing to do in order to process reports from our archaic system. In my case, select via formula isn't accomplishing my goal (though I could be missing something).