What in db formula can I use to add "IoT" at the end of a value name in column "category" if "IoT" exists in a different column. I dont want to create a brand new column, but I want to just alter the current column. I also have a lot of different category values so I would prefer a formula where I dont have to list all of them out and say if Contracted and flag IoT then Contracted IoT. Is there some sort of way I can do this with concat?
current data:
| Flag | Category |
other | Contracted |
| IoT | Contracted |
| IoT | COAM |
other | COAM |
| other | Expired |
desired outcome:
| Flag | Category |
other | Contracted |
| IoT | Contracted IoT |
| IoT | COAM IoT |
other | COAM |
| other | Expired |
