[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

Kelvin1 (Kelvin ) November 17, 2022, 8:51am 4

hi @Gokul001
I was tried using this dtTable.DefaultView.ToTable(False,“Relationship”) but it didnt work, do u know why?

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