[image] So guys i have an excel like this, i only want to take the data from code which have code 003. But i only need the relationship value which is “Not single” in this picture

Hi! Try this: Read range - output - dt_Out For each row in data table - Pass the dt_Out Now take one if condition and pass the expression like this CurrenRow("Code").ToString.Trim.Contains("003") And CurrenRow("Relationship").ToString.Trim.Contains("Not single") Now you will get the data whose …

How to get value from specific Column

Help Community

Gokul001 (Gokul Balaji) November 17, 2022, 8:49am 3

HI @Kelvin1

You can try with Filter Data Table activity

Check out this blog

Regards
Gokul

Topic		Replies	Views
How to get the corresponding values from another column if the value gets matched in the first column Activities excel , activities , question	11	5275	February 14, 2022
Data Manipulate Studio	6	680	July 14, 2022
Get a particular record in a datatable Activities datatable , excel , studio , question	6	1148	January 1, 2022
Extract excel data Help studio	9	1564	July 29, 2019
Search for a specific value in a column (CSV file) & put out the related value of another column Studio excel , activities , question	3	1424	March 12, 2020

How to get value from specific Column

Related topics