You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

TRIM DATA on DATA MANAGEMENT

Accepted answer
25
Views
7
Comments
edited Dec 22, 2020 12:38PM in Planning 7 comments

Content

Hello,

I've got a file which has been extracted from source with an space character on the numeric data as the thousand separator.

When importing, if the file type is set as "Numeric data" in the import format, data management will remove those lines with the space character. 

So I've set the file type as "all data type" and all lines are getting imported.

Now I'm trying to remove the blank spaces with a SQL mapping but it's not working.

This is the code:

CASE
WHEN DATA LIKE '% %' THEN '%'
ELSE
DATA
ENDCASE

I've also tried with AMOUNTX instead of data , but still no lucky.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!