journal workflow

Question

I have a column called "Revenue Category" and all the values in it are supposed to start with "RC" and if there are other values in it like "Spend Category" items that start with "SC" or just other values besides "RC" I need to add a check that flags it for review. So how would I do this?

binu_acs · Answer

@meghant03

ChrisTX · Answer

It will not be replaced by a 0 or 1.  Above I mentioned:  create a new field

Can you provide sample input data and expected output?

meghant03 · Answer

i don't want it to be replaced by "0" or "1" instead I need another column to show those values as it is. So like if a "Revenue Category" item has a value that begins with "SC" then I need another column called "review" that shows that "SC" value as it is in that column