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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamicly select the start row based on a name

Meteor

Hi,

I have an excel file where the start row keeps changing. The only constant is one of the column Names. Is there a way I can use the column name to identify the first row to import from?

Thanks

 

Alteryx Certified Partner

Do you mean to use a value within the constantly-named field to identify the starting position? If so, use a RecordID field on the file. A Filter tool can filter where <Constant Field> = <Starting Value> and that will give the starting RecordID value. Append that Starting ID value and use that to filter the data.

 

I have attached an example solution. Let me know if you have any questions.

Meteor

Thanks Charlie, this is exactly what I was looking for.

Labels