Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Return the row number of a certain value


I want to know which row number is my data starting from. Each set of data has "Customer name" in the field names.

Here is a sample of one of the datasets

1 Schedule 
3 Factory NameBranch NameCustomer name
4 Ax1
5 Ax2
6 Cx3
7 Sx4
8 Dx5


I want 3 as output because that is the row number where one of the columns has "Customer Name". (Column number of "customer name" can keep changing through different datasets)


Thanks in advance

Alteryx Certified Partner
  1. Add a Record ID tool to number your rows
  2. Use a Multi-Field Formula tool to flag the row that contains "Customer Name"

Could you please describe/show how to use multi-field to flag the row?

Alteryx Certified Partner
Alteryx Certified Partner



you can add a RecordId to create an identifier for the row, then prospose the data set using RecordId as a Key field and filter the row containing "Customer Name" as a value. RecordId will return the row number. I've attached a sample workflow.


Best regards



Alteryx Certified Partner

Hi @khans9 


Here are two approaches. The second one (which doesn't use Multi-Field) is actually a little simpler so I'd recommend that instead.


Screenshot 2019-05-15 at 16.56.19.png


Thanks a lot. Problem solved!