topic Re: Maximum character in a field in QlikView

Maximum character in a field

Mon, 18 Jun 2012 06:40:07 GMT

Hi all,

i have a case in here,

i have 2 different fields (AccountNumber and PinNumber) loaded from SQL Server to a qlikview,

AccountNumber (10 characters) and PinNumber (3 characters)

the problem is when i join both these fields as

Load

AccountNumber + pinNumber as ContractNumber

;

the result shows a new field ContractNumber with only 10 characters,

is there any limitation for characters in QlikView?

how i change the format or limitation?

Thanks

Re: Maximum character in a field

Miguel_Angel_Baeyens — Mon, 18 Jun 2012 06:53:47 GMT

Hi,

If all values are numeric, this is the expected behavior, because the "+" sign means "sum" instead of the one you want to use "&" (concatenate).

So this should work:

Load

AccountNumber & pinNumber as ContractNumber

;

Hope that helps.

Miguel

Re: Maximum character in a field

Mon, 18 Jun 2012 07:32:04 GMT

Thanks Miguel,

the result seem correct

Miguel Angel Baeyens wrote:
Hi,
If all values are numeric, this is the expected behavior, because the "+" sign means "sum" instead of the one you want to use "&" (concatenate).
So this should work:
Load
AccountNumber & pinNumber as ContractNumber
;

Hope that helps.

Miguel