Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago
Solved

How to duplicate the column and replace G with missing value ?

Hi All I have the field name = GROUP_TYPE , It have G1 , G2 ......  I like to create another column , that is copy all the value label except "G" So it will return as below :- G1...G1 G2.....
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hello

     

    G is the minimum LEN =1

    if(Len(Groupp_Type)>1,Group Type)