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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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