2 Replies Latest reply on Jul 29, 2020 2:34 AM by 1060285

    leading/trailing spaces


      HI All,


      Is there any option to drop leading/trailing space for the alias load.

      For eg:

      My source file is as below. if there is extra space on 2 column members for Quarter1 . I want it to get dropped.  Any suggestions please.


      $ALT_NAME 'Quarters'
      Qtr1 Quarter1
      Jan January
      Feb February
      Mar March

      alter database load alias_table


      Thanks in advance !!