6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Discussions

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

Dynamicly select the start row based on a name

racoon
7 - 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

 

3 REPLIES 3
CharlieS
17 - Castor
17 - Castor

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.

racoon
7 - Meteor

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

Deliverance
7 - Meteor

Thanks for the example, this was exactly what I needed. I was trying to figure out some RegEx method which I have no experience with.

Labels