Data table value fetch

how to get the column values of data table in list/array of string ??

@Sakshi_Jain - Please post some screenshot of your input and expected output always? That will help us in understanding your query more clearly …

Index Code Date Bool Bool2
10 ABCDEF 15.03.2019 TRUE TRUE
20 DEFGHI NA FALSE FALSE
30 EDFTHI NOT FOUND TRUE TRUE
30 EDFTHJ 17.03.2021 FALSE FALSE
40 ZZZZZZ 15.03.2021 FALSE FALSE

I have a string i.e. code , i need to seach in column code get the row number and update the bool column as false for that row

for example i search for code = "DEFGHI "
get row as 3 store in variable
update column(“Bool”) as False

then check condition if true
update column(“Bool”) as “True”

Sample_DT.xlsx (8.3 KB)