topic Re: Re: Disable Trim-function in QlikView

Disable Trim-function

kris_vliegen — Tue, 17 Sep 2013 14:45:04 GMT

Hello,

I have 2 fields that I wan't to concatenate.so I can use them in a key.

MATNR = CHAR 18
GRUND = CHAR 10

The field MATNR is filled till the 13th position.

The result I get is "NHCTOY006A_RCB12202556"

And the result I will see "NHCTOY006A_RC B12202556"

How can I disable the automatic trim-function?

Regards,

Kris

Re: Disable Trim-function

Tue, 17 Sep 2013 15:06:15 GMT

Hi Kris

I'm not sure what you are trying to achieve, are you trying to get 1 space or 5 (18-13) spaces between NHCTOY006A_RC and B12202556?

If it's just a space you need, then simply use;

MATNR & ' ' & GRUND as Key,

If you are looking to have MATNR come through as 18digits, this may take a bit of a more fancy formula. As even though your source system allows up to 18 characters, that does not necessarily mean it is holdiing 18characters.

Can you clarify a little more what you are trying to do and I'll see if it's some I can help with beyond that written above.

Regards

Steve

Re: Disable Trim-function

kris_vliegen — Tue, 17 Sep 2013 15:08:24 GMT

I would have 5 spaces or if the field only get 4 characters I will see 14 spaces

Re: Disable Trim-function

swuehl — Tue, 17 Sep 2013 15:15:19 GMT

Look into the VERBATIM system variable.

Re: Disable Trim-function

Tue, 17 Sep 2013 15:18:53 GMT

Yes, in your load script use;

Set Verbatim = 1;

That should keep any characters if they exist in the source system.

Steve

Re: Disable Trim-function

kris_vliegen — Tue, 17 Sep 2013 15:19:20 GMT

I've tried this http://community.qlik.com/thread/10226

But that doesn't work for me. I don't know what I(m doing wrong

Re: Disable Trim-function

swuehl — Tue, 17 Sep 2013 15:23:49 GMT

Hard to say.

Try also the text() function:

text(FIELD) as FIELD

Re: Re: Disable Trim-function

Tue, 17 Sep 2013 15:35:21 GMT

There is an ugly way of getting it done. Simply use a mapping table with spaces and plug in the relevant number of spaces depending upon the length of MATNR.

I've attached an example.

It's not pretty but it works.

Steve

Re: Re: Disable Trim-function

kris_vliegen — Thu, 19 Sep 2013 09:47:20 GMT

Thanks for the answers.

In stead of trying to have the spaces after MATNR we have deleted the spaces in the other key-field.