Skip to main content

[DSP / Collect] Forcing Appropriate Space when Blanks are Incorrectly Displayed

Caroline St.John
  • Updated

Issue

Empty strings are populated where there should be a space (specifically, the HANA char(1) data type will force a space over a blank when using an ODBC data source).

Resolution

  1. Select Collect > Administrative > Connection Types in the Navigation pane.
  2. Click the Sources icon.

    Collect_Connection-Types_Sources.PNG

  3. Click the Data Type Conversion icon for the ODBCHAHA SOURCE CONNECTION TYPE.

    Source-Connection-Types_Data-Type-Conversion-icon.PNG

  4. Click Add; create a new record using the following data:

    PROCESS ORDER

    		 Less than the existing CHAR Connection Type Data Conversion Record

    DATA VALIDATE CONTROL

    		 Data Type and Length Match

    PROCESS FLAG

    		 Accept

    DATA TYPE

    		 Char

    DATA LENGTH

    		 1

    NEW DATA TYPE FORMAT

    		 NCHAR(1)
  5. On the Vertical View, configure the following properties:

    Data Precision 0
    Data Scale 0
    New Data Type NCHAR
    New Data Length 0 or 1
    New Data Precision 0
    New Data Scale 0
    Column Override Template "Enter 1 space"
  6. Build the package.
    1. Select Targets in the Navigation pane.
    2. Click the Sources icon for a Target.
    3. Click the Build and Refresh icon for the appropriate Target Source.