Return the row number of a certain value

[khans9]

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
2
3		Factory Name	Branch Name	Customer name
4		A	x	1
5		A	x	2
6		C	x	3
7		S	x	4
8		D	x	5

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

[jamielaird]

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"

[khans9]

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

[RolandSchubert · Accepted solution]

Hi,

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

Roland

[jamielaird]

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.

[khans9]

Thanks a lot. Problem solved!