3 Replies Latest reply on Sep 27, 2018 3:20 AM by Okechukwu Ossai

    Removing half Null values

    Lokesh Gosain

      Let us suppose I have two column names. 1) Client Type and 2) Agency.

      In Client Type, there are different values with some nulls. Let say Total rows=1000, null rows=600.

      And in Agency all the 1000 rows are null.

       

      I want to pick these 600 from Agency column and rename them, group them, anything.

      In other words, I want to rename the values corresponding to these 600 rows from client type in Agency column.

       

      P.S. I've used IIF, i.e. IIF([ClientType], 'True', 'False')

      But this is not working.