How to get value from specific Column

Help Community
,
1

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

2

NOTE : I want doing this dynamically, cause the data not always be like that

3

HI @Kelvin1

You can try with Filter Data Table activity

Check out this blog

Regards
Gokul

4

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

5

Hi!

Try this:

  1. Read range - output - dt_Out
  2. For each row in data table - Pass the dt_Out
  3. 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 code is 003 and also his relationship is not single in the then block

In else block you will get the rest of the data

Another Approach:

Use Filer Data Table

FilterDtFo
FilterDtFo807×571 15.5 KB

Regards
NaNi

6

Have you tried with Filter data table? What is the output for that input you shared? @Kelvin1

7

after reading the data in the excel spreadsheet into a data table you can use the “For each row in data table” activity to iterate through the whole spreadsheet. and then use “CurrentRow.ItemArray[].Tostring()” to the get the value

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.