Can anyone help Based on one Column value fetch another column values

I am trying to fetch column data based on another column value
In my Example i have SLNO column values 1 and i want to fetch another column values upto 1 in my SLNO column

1 Like

Did we try with LOOKUP DATATABLE Activity here,
If we want to get the corresponding value from a column for the given value

Or

If we want to get all the rows based on one value from a column then we can use FILTER DATATABLE ACTIVITY where the sequence will be like this
—use a excel application scope and pass the file path as input
—inside the scope use read range activity and get the output with a variable of type datatable named dt
—now use a FILTER DATATABLE ACTIVITY and mention the input datatable as dt and output datatable as dt again
And in the filter condition mention the columnname between double quotes under column field and condition as CONTAINS and the value as “1”

Cheers @Arun_Pondhe1

2 Likes

Use Read Range activity to read the data into a data table and use filter data table activity with a condition SLNO Equals 1.

Regards,
Karthik Byggari

1 Like

Not Getting …I am trying to whenever 1 is present in SLNO column fetch the other column value at the upto last 1…then again for 2 then for 3…as long as…

1 Like

Get the unique values from SLNO column.

dtUniqueSLNO = DT.DefaultView(true,“SLNO”).CopyToDataTable

ForEach row in dtUniqueSLNO
  strSLNOValue = row("SLNO").ToString //if integer do conversion
  Filter Data Table Activity with a condition SLNO Equals strSLNOValue
  ....
End For

It will repeat for all SLNO.

Regards,
Karthik Byggari

2 Likes