Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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