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 ?)
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)