Keep only specific two rows in Datatable and remve remaining rows

Help Studio
1
  1. How to keep only Is Team Requisition: & Is Team Received: rows in DT and remove remaining rows from DT.
  2. Store Team Requisition: & Is Team Received: row value to 2 str variable

Note : Please refer attached excel for Datatable data
projectpcdata.xlsx (9.8 KB)

2

Hi @Sathish_Kumar_S
Read all data from sheet and you can use the filter data table activity and keep only rows with specific values.

image
image768Ă—484 17.9 KB

3

How to assign those 2 rows values ( Available in “Status” column) in to 2 string variable?

4

Hi @Sathish_Kumar_S -

image
image737Ă—137 7.6 KB

5

@Sathish_Kumar_S

Use this

dt.AsEnumerable().Where(Function(a) a(0).ToString().Equals("Is Team Requisition:")).First()("Status").ToString()

dt.AsEnumerable().Where(Function(a) a(0).ToString().trim.Equals("Is Team Received:")).First()("Status").ToString()
1 Like
6

Actually , i want to loop through DT after filter and store 2 rows values ( “Status” column) to 2 different String variable

7

Hi @Sathish_Kumar_S

Try this

image
image870Ă—1098 55.4 KB

image
image767Ă—484 19.5 KB

strTeamRequisition=DT.Rows(0)("Status").ToString()
strTeamReceived=DT.Rows(1)("Status").ToString()

image

projectpcdata.xlsx (10.8 KB)

Main.xaml (17.8 KB)

Cheers!!

1 Like