3 Replies Latest reply on Nov 8, 2016 4:56 AM by shripal gandhi

    How to assign Field values the same alias?

    ABRAHAM PETER

      Hi,

       

      My objective here is to get rid of the unwanted space in the field value.
      Here is an example:- (sample workbook attached)
      Field value (' VALID') has an unwanted space in the beginning.Need to fix this issue so that there will be only 1 field value with the name 'VALID'
      and show it in the bar chart as 'VALID' - 6 records

      Tried with editing the alias, but not helping.

      Is it possible to fix this out rather than removing the unwanted space in raw data.?

       

      Thanks in advance

      Regards

      Abraham Peter