Maximum character in a field

[#1]

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

[Miguel_Angel_Baeyens · Accepted solution]

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

[#3]

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