Main.xaml (8.2 KB)
Here I used this process to Update status as “Bad” when containing Numbers in “Address” column. When I tried this process “Status” is coming as “Bad” for all the columns which contains numbers and Alphabets but I want “Status” as “B” for the columns containing only number i.e for 5th row “Address” is 4.8 (decimal), it seems incorrect so Status should come as “Bad” and in the same manner for 6th,8th and 9th rows it has numbers only(506,39,6.1) which are wrong for “Address” so “Status” should come as “Bad”. So I want to update “Status” as “Bad” for these columns, how to do?
Input I gave
Output I want
So can anyone please suggest some idea to get rid of this problem. It would be of great help if anybody gives some idea.
Thanks and Regards.