flag data

[Krish2459_58]

Hi,

I have a column were i need to derive a flag as .

If first character starts with "F" as good else " Bad".

Thanks..

[MayilVahanan · Accepted solution]

Hi

Try like below

If(Left(Columnname, 1) = 'F', 'Good', 'Bad')