How to fetch corresponding value in a datatable based on a value

Help
, , ,
1

hi good day developers, i have a question here. i have an excel table as follows

ques11
ques111273×151 13.5 KB

i have a variable with list of stored SO Number. based on that SO Number i want to fetch selected corresponding value which is column “Project” and column “Date”. so for example if the SO Number is SO0392406, i want to fetch its corresponding value from column “Project” and Column “Date” which is PRU01-0120 and 6/11/2019. the variable list a has many So number and i want to fetch all respective column related to that so numbers, i will be grateful for the help. thank you.

2

@Yusuf_Rahmaniac,

You can try with Filter datatable activity to filter and retain the required rows/values.

3

Read the excel file into a datatable using Read Range activity.

For each soValue in ListSO
              dr[] = DT.Select("[SO Number]='" + soValue + "'")
              //if so number found
              if dr.Length > 0 Then
                  strProjectName = dr(0)(9).ToString //9 - column 10 (J)
                  strDate = dr(0)(1).ToStrintg //1 - Column 2 (B)
              end if
4

Use if condition in a for each row loop

image
image599×808 21.1 KB

5

thank you for help sir. it helps for my need.

6

@Yusuf_Rahmaniac You are welcome! I am glad that I could help you out.

7

You may try Filter datatable activity to filter or use datatable.select