Rows extraction

I want to extract the row containing dynamic keyword.
I have a excel sheet with some rows, i want to search in the excel sheet for the rows where first column contains that dynamic keyword . then i need to get all column data of that particular row with that dynamic keyword .

Thanks

Hi @Riya_Sharma

Your Steps would be as follows below

Use Input Dialog box to Input the Dyamic Keyword!

Read Range the Excel

For each row in readDt

Use Assign Create a new Dt Var NewDt=readDt.Select("[YourColumnName]=’"+YourInputVar+"’).CopyToDatatable

OutSide the body of loop Use write Range and write the newDt

Regards

hi @Riya_Sharma

Yes it would extract all the values

Suppose If you re inputting the value say “John”

Assume that excel Sheet having the Column name like Name ,Lastname, Age

The datatable.select method will fetch the Datarow Containing John and Convert it to datatable!

Hope the explanation Clears You!

Regards

hi @pravin_calvin

Can you pls send me the xaml?

Thanks

Hi @Riya_Sharma

Please refer to the xaml for starter help!

test_Xaml.xaml (9.1 KB)

Regards

Hi @Riya_Sharma

Instead of Buildatatable use can you read CSV activity and for writing we can Use write Csv.

Regards

Hi @pravin_calvin

Can u pls tell me how to avoid use of input dialog?

Thanks

Hi @Riya_Sharma

You can Try Storing the Variable Containing the result value!

StrVar =“YourSeachvalue”

Regards

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