Excel Data Extraction based on a specific word

Learning Hub
4

Hi @DadouSan

I saw the file it has two columns where the first one is for the days (today, tomorrow etc) and the second column is the description of the weather (Used google translator to understand the data :D)

So you can filter the data table with the keyword sunny (晴れ) (I hope this is the correct word in Japanese, if not you can use the exact word in the query below ?)
image

Note that your excel columns do not have any header so UIPath read range activity will take Column0, Column1 as two headers. Make sure you uncheck the Add Header checbox of read range activity.

Note : If by chance you get “ CopyToDataTable is not a member of datatable ” issue then this link will help you to fix: AsEnumerable is not a member of ‘System.Data.Datatable’

Please find the attached zip file to run the XAML file.
DadouSan.zip (9.9 KB)