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 NameBranch NameCustomer name4 Ax15 Ax26 Cx37 Sx48 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

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

Datasets

Accepted answers

RolandSchubert

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.